Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Dealing with Addresses Expand / Collapse
Posted Friday, June 13, 2003 12:00 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:13 AM
Points: 3,407, Visits: 3,026
Comments posted to this topic are about the content posted at

LinkedIn Profile

Newbie on
Post #13195
Posted Tuesday, July 1, 2003 3:20 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, February 27, 2007 12:21 PM
Points: 342, Visits: 1
This is pretty wierd as I started working on exactly the same kind of project today, and my comapny is also too poor to afford the PAF files ...

I have over 30,000 addresses and need to match them to 10,000 customers. I still need to add the 30,000 and then have a hierarchy of 30,000 including the 10,000 customers. As I match I need to update the address from the 30,000 file ( as that is more accurate).
The 10,000 customers come from a Cache database and are stored in a different format to the 30,000. The 30,000 (when extracted) are actually in a condensed form of the addreses you dealt with (e.g. if the address consisted of 4 fields the Country would be the last, whereas the next address may consist of 7 fields with the Country the last).

I must admit that most of the suggestions where in the idea box already (Great minds eh?) but I hadn't thought of using Soundex, which I am going to look at now. The merging program will be written in C# and I would be extremely grateful if you would consider swapping notes. If you would please contact me.

I'll post any tips I come across,


Steve Brett


Post #66531
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse