Compair two tables

[Michelle]

I would like to take a known list of street addresses and
compair them to the addresses of people in the current
database. I have a table of "known people"
LName
FName
Address
Address2
City
State
Zip
And a table of "known addresses"
Address
Address2
City
State
Zip
What I want to be able to do is compair the "known
people"'s address to the "known address" list however I do
not want to compair the exact address i.e. search only on
the street name not the entire address.
Please help

 

[Dale Fye]

Good luck!

In my experience, addresses are the absolute worst form of data to work
with. Generally, people don't normalize address info like they should. It
should be broken and stored in its component parts (streetName,
streetType[ST, RD, CT, LN, ...], and streetNumber, AptNo). Additionally,
people will abbreviate information in the address so that the following all
have the same meaning:

155 W Main St
155 W Main Street
155 West Main St
155 West Main Street
155 W. Main Street
155 W. Main St

and on, and on, and on.

My first recommendation would be to spend a lot of time working on the
address fields to make sure that these kinds of things are standardized.
Once that is done, your job should be a lot easier.

Dale