[dba-SQLServer] Addresses in Europe and elsewhere

Two things to consider: the foriegn clients will probably know
the correct formatting for their local address, and will this local format
get you out of the USPS without a problem. So you may want
to keep this format and your own broken down by elements
of the address.
There are commercial address cleaning firms if you have a large volume.

First stop

FRANK'S COMPULSIVE GUIDE TO POSTAL ADDRESSES
Effective Addressing for International Mail
http://www.columbia.edu/kermit/postal.html

Postal Codes and IPU or UPU
I can't remember why this was changed
from International Postal Union to Universal

http://www.upu.int/index.html

http://www.embassyworld.com/data/Zip_Codes.html

artful at rogers.com wrote:

>I'm looking for some input from various regions around the world. I have the USA and Canada covered, but I need info from elsewhere. In North America, the usual form of a mailing address is:
>
>  <code>
>  [StreetNumber] [StreetName] [Suffix]
>  [City], [State/Province]
>  [Postal Code]
>  [Country]
>  </code>
>  
>I know that in The Netherlands, the convention is to place the [StreetName] first, followed by the [StreetNumber]. By suffix, I meant such appendages as "Apt. #306". Then again, in various relatively rural parts of Spain, there are no street addresses. Here is an actual example of same:
>
>Brens-Cee    <-- 5 towns on La Finisterra (NW corner of Spain)
>Fadibon    <-- immediate town of interest
>La Corrunna    <-- largest city in that part of Spain
>Spain    <-- nation
>
>Arthur
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada