Case sensitive SQL search
Posted on 2003-11-13
I have a SQL server 2000 installation which is setup without a Case Sensitive collation. I was wondering does anyone know how I can perform a case sensitive search on the following:
WHERE Col002 = 'Y71Xe' AND Col003 = 'P'
I have tried the following, but cannot seem to get it to work:
WHERE (Col002 = CONVERT(varbinary, 'Y71Xe')) AND (Col003 = 'P')
In addition I will need to perform a table join with case sensitivity on the joining column.
Any Ideas? Cheers