RE: Zip code translation

Paul,

I looked around for a free zip-code file, and found
http://www.census.gov/geo/www/tiger/zip1999.html

It's a little dated, but should get you most of the way to your destination.
A caution; zip code is not a bullet proof way to derive the state, since
some zipcodes are common to multiple states.  But it shouldn't matter to a
large extent.  I did not download the file, but hopefully it will help.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: pnelson@xxxxxxxxxx [mailto:pnelson@xxxxxxxxxx]
Sent: Friday, January 28, 2005 7:14 AM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: Zip code translation


<FONT face="Default Sans Serif, Verdana, Arial, Helvetica, sans-serif"
size=2><DIV>I'm at a client doing a conversion from one software package to
another. The old package has a combined city/state field. The new package
has the city and state separated into two fields. Does anybody have a table
that would help me to derive the state based on the zip
code?</DIV><DIV>&nbsp;</DIV><DIV>Please send it to my private email address
since this list does not permit attachments. This is a V5R2
system.</DIV><DIV>&nbsp;</DIV><DIV>Thanks<BR><BR>Paul&nbsp;Nelson<BR>Arbor&n
bsp;Solutions,&nbsp;Inc.<BR>708-670-6978&nbsp;&nbsp;Cell<BR>pnelson@xxxxxxxx
om<BR><BR></DIV></FONT>