Names Names Names Bill William Pat Patrick

[P G]

I need to develope a program to search threw a list of
clients compairing them to another list we get monthly.

Thing is it is unlikely names will match exactly. I would
like to take into conciderations name variations such as
Bill/William, David/Dave, Pat/Patrick.

1. Anyone know a module that would do this? (I doubt it)

2. Anyone know a web site that might list various name
purmutations. (Im beggin this exists)

Thanks

 

[??]

CMap OK??

 

[Arvin Meyer]

It's unlikely that the names will come all by themselves. They most often
are accompanied by other data, a phone number, or address, etc. that at
least part of which could be matched.

The other possibility is to make one monsterous case statement that looked
for the majority of the nicknames.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Tom Wickerath]

In answer to your second question, an Access add-in named Splitter for Microsoft Access
includes a database that currently has over 18,000 first names in it. This information is
stored in an Access table, so it would be fairly easy to import the table into your
database.

http://www.infoplan.com.au/splitter/

Tom
___________________________________


I need to develope a program to search threw a list of
clients compairing them to another list we get monthly.

Thing is it is unlikely names will match exactly. I would
like to take into conciderations name variations such as
Bill/William, David/Dave, Pat/Patrick.

1. Anyone know a module that would do this? (I doubt it)

2. Anyone know a web site that might list various name
purmutations. (Im beggin this exists)

Thanks