on 8/28/02 10:03 AM, Frode at fstroemm@o... wrote:

> What is a good approach to match customer name,address etc. from my
> company database to the other ones. (To get phone numbers,emails fex.)

Can be a VERY tough process. Depends on the source of the names: Free text
entered by undisciplined operators or imported from purchased name lists.

Say you got stuff from Dun & Bradstreet AND you used their DUNS number. That
would give you a very nice unique ID for each entity.

Free text? It will take the comparison of several columns to determine if
you have a dupe or not: Trust the Name the least. Telno, address, zip...

There are schemes where you take the few chars from the name, address, city
and maybe telno and create a unique ID. You might be able to do that
independently on each system and then run your comparisons.

=Alan R.