Re: US Zip codes

Based on the file below,  many  zip codes cross state lines
10004 - NY and NJ
37642 - TN and VA
38041 - AR and TN
38063 - AR and TN
38079 - KY and TN
38852 - AL and MS
42223 - KY and TN
51630 - IA and MO
51640 - IA and MO
52626 - IA and MO
52761 - IA and IL
55954 - IA and MN
56027 - IA and MN
56129 - IA and MN
56219 - IA and SD
57638 - SD and ND
59221 - MT and ND
65733 - AR and MO

i stopped looking at this point (this file fits easily into excel, or to
download
to iSeries. Scan the word "part" their term for part 1 state, part another.

I've been in that situation where flat files are hard to update.
I would suggest a called program you can plug into various programs.
Check zip code file, and only if 2 states involved, either prompt user
to specify, or read address lines from bottom up, right to left, to find
state.
May still need to prompt user. Consider adding a new external file for
something like order# (key) and state code (in your case), rather than
change
flat file and a thousand programs.  Later, when doing major changes,
reintegrate state code back into order file. Sometimes database
design and corporate reality don't mix.

jim


----- Original Message ----- 
From: "John Myers - MM" <jmyersmm@xxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Saturday, October 04, 2003 3:01 PM
Subject: Re: US Zip codes


> Check out:
>
> http://www.census.gov/geo/www/gazetteer/places2k.html
>
> The file zcta5.txt has a list of all Zip Codes by state ... and lots of
> other goodies!
>
> John Myers
> Strategic Business Systems, Inc.
> 17 S. Franklin Turnpike, Ramsey, NJ 07446  USA
> E-mail: mailto:jmyers@xxxxxxxxxx   Phone: +1 (201) EASY 400   x131
> Web:    http://www.sbsusa.com      Fax:   +1 (201) 327-6984
>