Case Sensitive Search on a Case Insensitive SQL Server

Most SQL Server installations are installed with the default collation which is case insensitive. Because of this it is difficult to determine the differences of a value in upper case vs. lower case. By using COLLATE clause we can force a different coll

www.mssqltips.com