Tag Archives: Case Sensitive Comparison

Performing a Case Sensitive Comparison when SQL Server is Configured as Case-Insensitive

A case sensitive check can be performed by casting both columns or constants to the VARBINARY type; see examples below:

Posted in SQL 2005, SQL 2008, SQL 2008 R2 | Tagged | Comments Off on Performing a Case Sensitive Comparison when SQL Server is Configured as Case-Insensitive