Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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


Group: General Forum Members
Last Login: Yesterday @ 5:59 AM
Points: 2,947, Visits: 1,929
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