>DECLARE @TestCS TABLE (Col1 text, pk int IDENTITY ); >INSERT INTO @TestCS VALUES('Test') >INSERT INTO @TestCS VALUES('TEST') >INSERT INTO @TestCS VALUES('test') >INSERT INTO @TestCS VALUES('TeSt') >INSERT INTO @TestCS VALUES('Test') > >SELECT * FROM @TestCS > WHERE col1 COLLATE SQL_Latin1_General_CP1_CS_AS LIKE '%Test%' >This is great code. Thanks