Like Match SQL statement?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have two tables from diffrent sources. 1 table is a list of our Company Customers and the 2nd table is from the Goverment of Denied Persons (Do Not Sell List). The problem is that there is not key field (i.e. Fed Tax ID, etc) to join them by. The Goverment list only has a Name and Address fields which are available from our Customers list.

Question: Is there anyway to create a SQL statement that looks at the name or address field and returns values that are like "*" matching each other? I have created many queries but I never had a request like this one. Any help would be much appreciated.

Best regards,

Tony
 
On Wed, 9 Jun 2004 16:54:02 -0700, "Tony Feole" <Tony
Hello,

I have two tables from diffrent sources. 1 table is a list of our Company Customers and the 2nd table is from the Goverment of Denied Persons (Do Not Sell List). The problem is that there is not key field (i.e. Fed Tax ID, etc) to join them by. The Goverment list only has a Name and Address fields which are available from our Customers list.

Question: Is there anyway to create a SQL statement that looks at the name or address field and returns values that are like "*" matching
Click to expand...

This can be a REAL pain in the neck. Is "Bob Wilson" the same person
as "Robert Wilson"? Or is Robert the dad who wants off the list, and
Bob his son who didn't sign the Do Not Sell request? Is "3310 W Main"
a match to "3310 West Main St." - and if so, how can you write a
*reliable* query expression to assert that? (LIKE will not work
because of the embedded 'est').

It is not surprising that commercial "list cleaning" services charge a
pile of money for this kind of operation; it often requires quite a
bit of manual processing.
 
Back
Top