Forget the service. Look at software from
http://worksright.com/ I am
just a happy customer. They send out monthly updates to the files. Sample
screen shot from one file:
Detailed information for ZIP Code 46755
Selected city name .............. KENDALLVILLE
Preferred city name ............. KENDALLVILLE
State name ...................... IN
County name ..................... NOBLE
County FIPS code ................ 18113
City abbreviation ...............
Telephone area code(s) ........ . 260
Time zone/Current Date & Time ..* E 0/00/00
Latitude (NAD-27)................ 414438
Longitude (NAD-27)............... 0852605
Postal facility code ...........* P
Postal mailing indicator .......* Y
Postal city delivery ............ Y
Postal carrier route rate sort .* D
Postal finance number ........... 174202
ZIP Code class .................*
Single ZIP Code city ............ Y
...
Can also be used for
- entering in zip code and automatically retrieving city and state.
- Distance between two zip codes. Which can be useful for "show all
stores in a 50 mile radius".
and the list goes on...
Numerous routines provided. You can write your own against the files.
I've written a few service program subprocedures that I've then built SQL
UDF's around.
Rob Berendt
midrange.com
