I just came across this after posting about this s...

2005-12-31T01:29:26.706+11:00

I just came across this after posting about this same thing last week on my blog. Interesting alternatives.....

http://randyjean.blogspot.com/2005/12/how-to-force-sql-server-query-to-be.html

Or, you could just use a case sensitive collation,...

2005-12-08T22:17:48.323+11:00

Or, you could just use a case sensitive collation, and then you may be able to continue to use your indexes (not in the axample below admittedly).

e.g.
USE Northwind

SELECT CustomerID, CompanyName, ContactName, ContactTitle, City
FROM customers (NOLOCK)
WHERE UPPER(LEFT(CompanyName,4)) = LEFT(CompanyName,4) COLLATE Latin1_General_cs_ai

Course, that assumes you're using SQL 2000. It won't work on SQL 7.

Owl.

Comments on Craig Bailey on Microsoft: SQL: Compare case in WHERE clause

I just came across this after posting about this s...

Or, you could just use a case sensitive collation,...