Re: Base table of U.S. Zip Codes
From: Gary Gapinski <gapinski_at_lerc.nasa.gov>
Date: 1996/04/23
Message-ID: <4lj24d$c5j_at_bytor.lerc.nasa.gov>#1/1
Date: 1996/04/23
Message-ID: <4lj24d$c5j_at_bytor.lerc.nasa.gov>#1/1
Hello, Kevin:
Use of a hash index should get you the response you need.
Hownever, you have another problem. There is not a one-to-one mapping between ZIP code and FIPS state code. To precisely identify the state, a nine-digit ZIP code may suffice, and you will probably have to use the street address as well. The number of mappings that aren't one-to- one are small, so you may be able to get away with using the 5-digit ZIP code if you choose to ignore them.
Regards,
Gary
-- __________________________________________________________ Gary Gapinski email: Gapinski_at_lerc.nasa.gov NASA Lewis Research Center voice: +1 216 433 5251Received on Tue Apr 23 1996 - 00:00:00 CEST