Match two Address lines to one another

[jabhawk]

I need to take two addresses and see if they match. The two strings may contain differences like "S" vs "South" and "Dr" vs "Drive".

I have done this in other applications but need a quick solution and do not have the time to design it myself from memory.

Anyone have a function to handle this type of compare?

Jon B


Jonthan A Black

 

[DSummZZZ]

SOUNDEX() may get you close, or a least close enough to do a more thorough comparison.
?Soundex('1234 S. Elm Dr.')
?Soundex('1234 S. Elm Drive')
?Soundex('1234 South Elm Dr.')
?Soundex('1234 South Elm Drive')


-Dave S.-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[gentforreal]

One way is to have the file Cass certified using industry standard postal software. This is something I do everyday... what it will do is "standardize" the address so that they all will be the same..

Ex: all addresses that have Avenue spelled out will be changed to Ave., Street will become St for each and every address ..... all addresses will be standardized to postal specifications. A bonus is you will find out what addresses are undeliverable, you will be the zip+4 code and if you want... maybe even the county or more added to your file.

Then you can easily match the addresses! The software itself is very, very expensive but... A local mail house will do this for you for only a few dollars depending on the size of the file. Hope this helps.

Will