Geoff writes "Hey,I was reading one of your posts on case sensitive SQL queries (http://www.4guysfromrolla.com/webtech/sqlguru/q022400-1.shtml), and I thought I just might throw in my $0.02. This solution to the original question is for the MS-SQL environment, I am not sure if it will work on any other DBs. You can convert the string value to a binary representation and compare the binary checksum values. /*******************START CODE*****************/--Declare test variablesDECLARE @Val1 VARCHAR(10), @Val2 VARCHAR(10)--Set test variables valueSET @Val1 = 'my value'SET @Val2 = 'My Value'--Compare Val1 & Val2IF Binary_Checksum(@Val1) <> Binary_Checksum(@Val2) --the two values do not match PRINT '@val1 does not match @val2, this process worked'/*******************END CODE*****************/
Hope this helps somebody!Have a good one.Geoff MinaSoftware Engineer | DBAIVR Inc., a Prosodie Companywww.ivrinc.comwww.prosodie.com716.929.1300 x 233"
Comments on Case Sensitive Search 
Posted - 2002-10-22 : 08:19:51