RE: US Zip codes

Then, Booth, I too suggest the WorksRight software.  They have tables, and 
programs you can call, that can relate these together. 

Like:

select z.zstate, rcm.ccust, rcm.cnme, rcm.czip 
from lyldivf/rcm rcm left outer join zclib/zccity z
 on substr(rcm.czip,1,5)=z.zcode 
order by z.zstate, rcm.ccust 

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/04/2003 12:30 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
<midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: US Zip codes






I have no interest in the zip codes themselves, only in their ability to
group customers by State.  Some States require a percentage of sales in
their state to total sales for tax assessing purposes.  I am hoping to 
avoid
populating a zipcode file whose only purpose would be to name the state.

 

 

 

---------------------------------------------------------

Booth Martin   http://www.MartinVT.com

Booth@xxxxxxxxxxxx

---------------------------------------------------------

 

-------Original Message-------

 

From: Midrange Systems Technical Discussion

Date: Saturday, October 04, 2003 12:18:31

To: Midrange Systems Technical Discussion

Subject: RE: US Zip codes

 

| -----Original Message-----

| [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Al Barsa

 

| My suspicion is that this information is not at all proprietary, because

| the USPS will deliver a letter w/o a zip code, but they don't like to. I

| suspect that either their is a web site, or you could buy a CD.

|

| It might make a good TAA Tool, ad a companion to DSPARACDE!

 

I started some work in this area over a year ago for my client, but we

didn't get real far. However, I do know that CD is available for a fairly

nominal charge from USPS, depending on number of states iirc, with 
periodic

updates (monthly or quarterly). The CD contained detailed info on valid

addresses down to street level. I did a query on zips/states, but don't

recall the results.

 

Also seen, but don't recall, what the license specifics were, as far as a

TAA Tool would go. (Tool would be useful, but probably could NOT include

the info on CD unless USPS was paid on per copy basis, and/or customers

already had CD.)
_______________________________________________
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.