Geeks With Blogs
Chris Breisch   .NET Data Practices
Search this Blog!

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.

Posted on Thursday, June 7, 2007 5:54 PM Database Practices | Back to top

Comments on this post: SQL Server and Sorting with Case Sensitive Collations

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Chris J. Breisch | Powered by: