samiksc

 Profile Answers by samiksc 

• Jan 19th, 2006

 

For case sensitive string comparison in SQL one has to use substring() and ascii() functions in the following way.

1. Get first character of both strings using substring function as substring(str1, 1, 1)
2. Find ascii value of both characters and compare.
3. Put statements 1 and 2 in loop to advance to next character

For example if (ascii(substring(str1, @pos, 1)) = ascii(substring(str2, @pos, 1)) then @pos = @pos + 1 ....