[dba-SQLServer] Addresses in Europe and elsewhere

Arthur,

New Zealand is as follows

[Suffix], [StreetNumber] [StreetName]
[Suburb]
[City]  [Postal Code]
[Country]

Regards

David

At 15/08/2006, you 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
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com