Monday, May 23, 2016

MS SQL - SELECT only words that start with UPPER Case (first letter capitalized)

select top 10 * from [TABLE] WHERE LEFT([Word],1) = UPPER(LEFT([Word],1)) COLLATE Latin1_General_CS_AI


This could also return words that start with a number. I didn't need to care for this case as most words that start with numbers are probably proper names too.