Tuesday, October 23, 2007

SQL string compare with accent-insensitive

I'm always forgetting the collation name used for this prupose.
How to compare strings without caring about accents:

select *
from t1 inner join t2 on t1.description collate SQL_Latin1_General_Cp850_CI_AI like t2.description collate SQL_Latin1_General_Cp850_CI_AI

2 comments:

Anonymous said...

Thats just great! Thx

Anonymous said...

There are various ways to take away a skin difficulty.
Scientific studies present that all-around four
in one hundred amongst Caucasian population acquire
dysplastic moles.

Feel free to surf to my web-site :: dermatend cream