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."
Article: Performing case sensitive searches in SQL Server
Posted - 12/21/2002 : 13:52:08
