SQL Server allows you to set a case sensitive collation at both the database and column level but often you will need to do a case sensitive search when everything is case insensitive. Not to worry, you can set the collation directly in the query. /* To test string equality including case when the DB is not case sensitive you must include collation as part of the test as follows: */ declare @mystring1 varchar(10) declare @mystring2 varchar(10) set @mystring1 ='abc' set @mystring2 ='ABC' -- by default ......