Make sure you understand how SQL Server treats Case Sensitive Collations. It's very much a dictionary sort and not an ASCII sort. What does this mean? It means it sorts things aAbBcC, not ABCabc as you might expect. So, if you do a WHERE value LIKE '[A-Z]%', you won't get all things that start with capital letters, you'll also get anything that starts with a lowercase b-z.
Details and example code can be found here.