>>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%' >>>