Re: How should I type my data- ZIP codes and States/Regions

In my experience it is far better to store zips as strings, especially if you ever intend to store international addresses (ever see a Canadian zip code?). I'm not sure I understand why you would even consider storing a state as a number.

HTH,
Jon Myers

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 Thu Apr 13 2000 - 00:00:00 CEST