Re: Duplicate mailing addresses

Paul's is certainly the best suggestion, if they still do that, but you
could also write routines to "squash" address yourself and then sort by
address and compare.  Our "squash" routine strips blanks and leading
zeros so your address below would look like this: 
123EGrandRiver compare to 123EastGrandRvr

This method would help, but the post office's service would be better.

http://www.usps.com/business/customersupport/welcome.htm 

hth

Dave B

>>> PaulMmn@xxxxxxxxxxxxx 03/22/2005 7:30:17 AM >>>
David--

Check with the post office.  They used to offer a service to convert 
addresses into standard format--  you sent them a file with your 
information in standard fields, and blank fields adjoining.  They'd 
convert your addresses to standard format (ie Street becomes St, etc).

I don't know if the service is still available, or if there's a limit 
on the number of addresses they'll process.

--Paul E Musselman
PaulMmn@xxxxxxxxxxxxxxxxxxxx 



>Any suggestions for a good way to find duplicate mailing addresses in
>our database.
>
>David Smith
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.