Case Sensitive Operator In SQL

[Creeder]

Is there an operator In SQL that allow you search a value using case sensitive mode? By using the "=" sign the select statement will not differentiate between "Test" and "test"

Thanks.

 

[tlbroadbent]

You can convert the column and criteria to binary and compare as in the following example.

SELECT * FROM TABLE1
WHERE CAST(Col1 AS VARBINARY(16)) = CAST('Test' AS VARBINARY(16)) Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[dbmsguy]

select * from test where lower(cola)='test'

would return

cola
----------
test
TEST

(2 row(s) affected) Paul

http://www.dbmsguy.com