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.
No comments:
Post a Comment