Re: How should I type my data- ZIP codes and States/Regions
Date: 2000/04/19
Message-ID: <DoiL4.836$q4.88540_at_petpeeve.ziplink.net>#1/1
If you store ZIP codes as strings, then when you begin to want to store
Canadian Postal Codes,
you will be able to use the same column. If ZIP is numeric you will need a
different column for
Canadian Postal Codes.
As far as state is concerned, the best bet is to use the same 2 letter
codes the US Postal Service does.
There are two letter codes for overseas territories, like PR = Puerto Rico,
and for
Canadian Provinces, like PQ = Quebec. I don't know where, but I'm sure
there's a website that
lists all of them.
Beatlebum wrote in message <39006301.200863187_at_news.supernews.com>...
>We are debating the relative merits of storing ZIP's and states as
>strings/numbers.
>
>Is there a de facto approach? What are the relative merits?
Received on Wed Apr 19 2000 - 00:00:00 CEST