Matching two non identical Company Names with LEFT

[derekstewart]

I am trying to match company names between 2 tables, both with hand keyed data. For this reason, the company names are different (i.e. Cardinal and Cardinal Inc.) I used a left 6, which in the example above would return CARDI and then matched it in query builder with a like "*" & [shortname] & "*" which works reasonably well. I found that it still isn't picking up a few names, due to a space, or underscore, or a dash. I replaced the spaces, with none, which helped, but would like to try and remove all non letters, which I belive will return close to 100% matches. Anyone know how to remove all non letters such as -_,.&? Then I will remove spaces and see how it goes. If anyone has a better idea of how to match the company names I would appreciate help there too. Thank you very much. D

 

[PHV]

You search for soundex

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244