Thanks, this is a great tip!
I think you probably meant to use the collation _CS_ in the example you gave on the WHERE clause. You have a SQL statement that uses _CI.
Here's what I'm talking about:
Check out this query where a case sensitive collation is used:
|SELECT * |
WHERE Value1 LIKE '%Test%' Collate SQL_Latin1_General_CP1_CI_AS
As you can see, only the 3 records where the 'Test' string is in mixed case are returned.
Anyway, I did know what you were talking about so it is not a problem. Thanks once again for the tip.