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 |
|
khagan
Starting Member
1 Post |
 Posted - 2008-09-24 : 16:04:34
|
| Hi,I have been asked if we can search a table for alternate names of people; such as Bob instead of Robert or Peg instead of Margaret, etc. I have hunted around and found terms such as Dimunitive, Hypocoristic, Content Equivalent and Keyword Substitution...but none of them have helped by providing code to search the table of names. I've also looked at phonetics but obviously they aren't going to return alias names.Has anyone ever seen or done this? I would appreciate any help in how to approach or solve this issue.Thanks in advance,Steven |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-25 : 01:25:39
|
quote:
Originally posted by khagan
Hi,I have been asked if we can search a table for alternate names of people; such as Bob instead of Robert or Peg instead of Margaret, etc. I have hunted around and found terms such as Dimunitive, Hypocoristic, Content Equivalent and Keyword Substitution...but none of them have helped by providing code to search the table of names. I've also looked at phonetics but obviously they aren't going to return alias names.Has anyone ever seen or done this? I would appreciate any help in how to approach or solve this issue.Thanks in advance,Steven
where's the information for mapping held? how will you know which name is alias for which name? |
 |
|
|
|
|
|
Alternate/Alias Name searching?