CODEWITHSUNDEEP
sqljoinsql-server-2008-r2characteralphabet
Joe Mc Clure
Joe Mc Clure

Reputation: 71

SQL Joining where data values may be Anglicized

I want to figure out how to join on a field when a user may have entered an English spelling of a word because of the keys available. This would be like replacing Küss with Kuss, François with Francois, José with Jose.

I've seen the terms "collation" and "regex" in several posts. I tried

    SELECT Company collate SQL_Latin1_General_CP850_CI_AI, Company
    FROM tblCompany

but my umlaut was still there, so that wouldn't join on where the umlaut wasn't used.

Any help to set me on a path would be greatly appreciated!

Upvotes: 0

Views: 65

Answers (1)

andreybavt
andreybavt

Reputation: 1321

Try a SOUNDEX function. It compares words that are spelled differently but sound simmilar : 

Select * from users where SOUNDEX(name) = SOUNDEX('José')

would give you lines for Jose and José

Upvotes: 1

Related Questions