You need the ISO 3166-2 list.
http://www.iso.ch/iso/en/prods-services/iso3166ma/index.html

The country code list is a free download but you have to purchase the
database with the subdivisions included.

Please fix your system clock. It's showing the wrong date/time.

--
David Portas
------------
Please reply only to the newsgroup
--

Hey im working on a worldwide system and i am trying to work out the best
approach to how i am going to Segment the world / Countries / States /
Provinces - Suburbs | Citys???

Any ideas cause i neet for people to be able to select on any level
i they may just select a Country or maybe the full country State Province?


My possible ide is to have a table

Location id - Location Name - Location Type - Upper Location
1 America Country Null
2 Los Angeles State 1

And for Citys maybe i could have another table

City ID - City Name - RelatedLocationid
1 My City 2


What do you think

Do you think every place in the world can be Segmented By Country - State -
Province / Suburb


Any one know where i could get a list like this!
Thanks!!