[dba-SQLServer] Addresses in Europe and elsewhere

artful at rogers.com artful at rogers.com
Mon Aug 14 10:59:53 CDT 2006


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





More information about the dba-SQLServer mailing list