Performing case sensitive searches in SQL ServerBy Bill Graziano on 21 December 2002 | Tags: SELECT 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."
|
- Advertisement - |