Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mathias
Posting Yak Master
119 Posts |
 Posted - 2004-02-27 : 02:30:46
|
| Hi,Is there any way to compare two words (in my case it will be first name + last name) in order to find possible duplicates:Example 1: John Chan vs Chan JohnExample 2: Schmitt vs SchmidtThanks, Paul |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-02-27 : 02:55:38
|
| The soundex function might be of use here. Look it up in Books on Line.eg select soundex('Schmidt'), soundex('Schmit')both return S253Duane. |
 |
|
|
Mathias
Posting Yak Master
119 Posts |
Posted - 2004-02-27 : 03:27:01
|
| Thanks, that the function I was looking for. What about comparing 'John Smith' with 'Smith John'? Is there a way to find the word in a different order? |
|
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-02-27 : 03:50:52
|
| Not that I am aware of.You will probably have to write a Function that splits the names up by identifying where the blank characters are and then evaluate these with soundex.Duane. |
|
|
|
|
|
|
Fuzzy comparison Schmitt with Schmidt