Non-US address

[J]

Someone told me that some non-US address do not have State/Province, and
some might not have Postal Code. Is this true?

[DA Morgan]

J wrote:

Someone told me that some non-US address do not have State/Province, and
some might not have Postal Code. Is this true?

Yes. And some might have things that aren't in a US address. For example:

3-1, Kudan-minami 1-chome
Chiyoda-ku,
Tokyo, Japan 102-8660

Chiyoda-ku has no US equivalent and not no equivalent for state.
Tokyo is in Kanto but you won't find that in the normal address
listing.
--
Daniel A. Morgan
http://www.psoug.org
da******@x.washington.edu
(replace x with u to respond)

[markc600]

Check out

http://www.upu.int/post_code/en/post...ountries.shtml

[Erland Sommarskog]

J (ju******@hotmail.com) writes:

Someone told me that some non-US address do not have State/Province, and
some might not have Postal Code. Is this true?

Yes, here in the outside world things are rough. You know, for our tiny
little country it would be preposterous to have a thing like states. Many
US states have a bigger population than we have. Besides, by tradition
this is a centralised country where the national government strongly
regulates what counties and municiplaties should do. In theory they are
free to set their on tax level, but the government meddles there as well.
On top of that, county and municiplatity borders changes sometimes, so
it would not be good for addresses.

We do have postal codes. And to make you feel a little more like home,
they are even five digit ones. However, there are really rough places
like the UK where the postal codes looks entirely different.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp