Doing a case sensitive search in a case insensitive SQL server

February 01, 2012

SELECT * FROM dbo.CaseSensitiveTestWHERE Value1 LIKE '%Test%' Collate SQL_Latin1_General_CP1_CS_AS
GO


http://www.mssqltips.com/sqlservertip/1032/case-sensitive-search-on-a-case-insensitive-sql-server/

You Might Also Like

0 comments

Popular Posts

Twitter