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

Check this http://dotnetsamplechapters.blogspot.com/2007/10/make-your-case-sensitive-searches-1000.html

I don't recall if this is the same article, but AFAIK idea is the same.