I am new to SQL server 2000 and 2005. Can anyone tell me why I am getting wrong results while executing the following simple queries
Ans: 10 (Deleted "T" from the word "This" and got the Correct answer)
You need to specify the strings as unicode strings, and use a collation that is at least case and accent sensitive. I have chosen the most sensitive Latin1 code page available for this query:
The results from this query are:
Also, note that your case 3 answer was not correct - it was returning the index of the first 't'.
answered Nov 09 '09 at 09:45 AM
Matt Whitfield ♦♦