Jan(?)
That's a tough one especially ones like Bill/William, John/Jack (never understood that one since they are both only one syllable). But you could find a lot of hits without using a table of nicknames.
WHERE FirstName LIKE "Da*"
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <jan.hertzsch@gmail.com> wrote :
It was tough to come up with a title for this.
I have a Voter Registration database that I am given. I try to match it with Contacts given me by a variety of sources. The only way I can match this is by name (in this case, I don't have addresses).
I do a match on first name and last name and get a decent hit rate. Most of the non-matches are things like Don/Donald, Betty/Elizabeth, Dave/David, etc. What I would love to do is set up a table of common nicknames and run the comparison against the different combinations. The table is easy but I can't think of a way to make the query work. Any thoughts?
Thanks
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar