SQLTeam.com Logo

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."