We are having an issue where we need to compare some address data to insure that we are not entering a duplicate record. (The data is coming from multiple outside sources, so an identity/GUID won't work... but thanks for thinking of that)
Consider the following
Company Name
Address
City
State
ZIP Code
If the first person was to send us:
"Bob's Restaurant"
"123 Main Street"
"New York"
"NY"
"10018"
and the second person sends us:
"Bobs Restaurant"
"123 Main St."
"New York"
"NY"
"10018"
Notice that the second restaurant does not have the appostrophy and the street name is abreviated. So an exact match is SQL would not work.
We're looking at Latitude and Longitude, and that should get us there, but in case anyone has any other thoughts..... thanks.
Question
James Rose
Hello gang,
We are having an issue where we need to compare some address data to insure that we are not entering a duplicate record. (The data is coming from multiple outside sources, so an identity/GUID won't work... but thanks for thinking of that)
Consider the following
Company Name
Address
City
State
ZIP Code
If the first person was to send us:
"Bob's Restaurant"
"123 Main Street"
"New York"
"NY"
"10018"
and the second person sends us:
"Bobs Restaurant"
"123 Main St."
"New York"
"NY"
"10018"
Notice that the second restaurant does not have the appostrophy and the street name is abreviated. So an exact match is SQL would not work.
We're looking at Latitude and Longitude, and that should get us there, but in case anyone has any other thoughts..... thanks.
Link to comment
Share on other sites
8 answers to this question
Recommended Posts