Cust table with country and state data
  Home FAQ Contact Sign in
microsoft.public.sqlserver.datamining only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... datamining Profile…
 Up
Cust table with country and state data         


Author: Andrew Baker
Date: Jun 12, 2008 16:56

While it is easy to make a customer table, I am looking for a setup that
references country and state information with prefilled state names.

So, I am looking for a country table with all country names (and preferably
their phone prefix) so
US, 1,
France, 33,
Australia, 61,
NZ, 64
, etc
the default domain extension would be great.
I know there is a standard defining the countries and their short form, so
meeting this standard would be great.

I am then looking for a state table with data, so
Aus, Qld, Queensland
Aus, NSW, New South Wales
Aus, Vic, Victoria
...
USA, Alaska, AL
USA, New York, NY
Show full article (0.75Kb)
1 Comment
Re: Cust table with country and state data         


Author: Eric Isaacs
Date: Jun 12, 2008 18:55

no comments