>>I guess you didn't read my SQL Column published in UtMag a while ago. :)
>>
>>

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

There is actually a better way with a better execution plan, but I forgot right now there I've seen this technique. I would search tomorrow.