Pattern Matching or Sound Alike

[BC]

Hello All,
I am looking for a function or algorithm to pattern match
addresses.
We have a large listing of addresses. Due to clients not
knowing what their correct street number is or liberally
interpreting it('12345th Street South' could be entered
as '12345 S Street') we have duplicate data. Is there a
way to prevent this by doing a evaluation of the address
using the Before Update preperty?
Even better, is there a address checking utility or
function that references the USPS database?

Thanks in advance.

Brian Clark

 

[Wayne Morgan]

Try a Google.com search for a routine called SoundEx. Also, there is a good
sample of this in the book "VBA Developers Handbook".

http://www.developershandbook.com

 

[Guest]

Thanks Wayne,
I have some wonderful code for the soundex type
algorithms.
Unfortunately they do not work with numbers, only western
style names.

Thanks again,

Brian Clark

 

[Wayne Morgan]

There are code routines that will convert numbers into their word forms
(i.e. 1200 into one thousand two hundred), if you did this first, will
Soundex work?