tag:blogger.com,1999:blog-2250002336318180046.post7771478208530075606..comments2022-03-24T01:29:06.101-07:00Comments on Tech Spot: Find rows with lower case characters in SQL ServerManesh Josephhttp://www.blogger.com/profile/12496266809178689757noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2250002336318180046.post-56160602595352805122015-06-16T16:46:18.002-07:002015-06-16T16:46:18.002-07:00Or you could change slightly (remove the first %) ...Or you could change slightly (remove the first %) to achieve the same result.<br />SELECT *<br />FROM Test<br />WHERE col1 <br />LIKE '[abcdefghijklmnopqrstuvwxyz]%'<br />collate Latin1_General_CS_AS<br />Darrynhttps://www.blogger.com/profile/00381632045400964877noreply@blogger.comtag:blogger.com,1999:blog-2250002336318180046.post-37321538714407861192014-04-11T08:11:21.293-07:002014-04-11T08:11:21.293-07:00Excellent. Thanks!Excellent. Thanks!Anonymoushttps://www.blogger.com/profile/16272717508421645855noreply@blogger.comtag:blogger.com,1999:blog-2250002336318180046.post-39507502663080980582012-11-01T10:44:00.037-07:002012-11-01T10:44:00.037-07:00Hi Mayukaha,
The aforementioned query is to retur...Hi Mayukaha,<br /><br />The aforementioned query is to return rows when atleast one lower character present in the value.<br /><br />For your requirement, try the following queries. I've just used "product_name" as the tbale name and "name" as the column name<br />1) Find product names start with an upper case character<br /><br />select * from product_name where <br />LEFT(name,1) = UPPER(LEFT(name,1)) COLLATE Latin1_General_CS_AS <br /><br />2) Find product names start with an lower case character<br /><br />select * from product_name where <br />LEFT(name,1) = LOWER(LEFT(name,1)) COLLATE Latin1_General_CS_AS Manesh Josephhttps://www.blogger.com/profile/12496266809178689757noreply@blogger.comtag:blogger.com,1999:blog-2250002336318180046.post-51360618138373361772012-11-01T09:22:24.159-07:002012-11-01T09:22:24.159-07:00I have a product name table with products names co...I have a product name table with products names collected both in upper and lower cases. I want to pull out product names that start with lower/uppper cases. <br /><br />Can this help ?MMhttps://www.blogger.com/profile/04423817772290414284noreply@blogger.com