Re: US Zip codes

SELECT SUBSTR(ZCODE,1,2), ZSTATE 
from zclib/zccity 
GROUP BY SUBSTR(ZCODE,1,2), ZSTATE

SUBSTR  STATE
  00     NY 
  00     PR 
  00     VI 
  01     MA 
  02     MA 
  02     RI 
  03     ME 
  03     NH 
  04     ME 
  05     MA 
  05     VT 
  06     CT 
  06     NY 
...

Clear enough?

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"Booth Martin" <Booth@xxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/06/2003 11:36 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
<midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: US Zip codes






Am I reading you right? That the first two digits 00 thru 99 could have a
state associated with it and be accurate? (I know 05 = Vermont for 
example).
Its OK if a few states have more than one set of digits, but that is not a
problem as I only wish to do a look up from the 2 digits. An array of 100
elements is not unmanageable. 
 
---------------------------------------------------------
Booth Martin http://www.MartinVT.com
Booth@xxxxxxxxxxxx
---------------------------------------------------------
 
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: Monday, October 06, 2003 11:05:19
To: Midrange Systems Technical Discussion
Subject: Re: US Zip codes
 
 
Jim,
 
according to my zccity file from worksright software, I found no zips that
span multiple states.
 
whoever said there were some, could you post an example?
 
rick
 
----original message----------
So does anyone have a true zip code file with State Code, to verify
which zip codes cross state lines?
Also, John - do you ever sell to Canada, Mexico, or anywhere else?
Be aware there are zip codes in some other countries that match 5 digit US
zip codes.
jim
 
 
.

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.