Return to Performing case sensitive searches in SQL Server
Performing case sensitive searches in SQL Server
Written by Bill Graziano on 21 December 2002
Narayana Vyas Kondreddi submitted "By default SQL Server is case insensitive, and performing a case sensitive search is not very intuitive. This article shows you how to implement case sensitive searches in SQL Server, using different techniques like conversion to binary datatype, COLLATE clause, BINARY_CHECKSUM function, computed columns etc."