DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Validate Zip Code against city/state

  1. #1
    Join Date
    Aug 2001
    Posts
    2

    Validate Zip Code against city/state

    Does anyone has the experience about how to Validate Zip Code against city/state under Oracle or MSSQL?

    Thanks.

  2. #2
    Join Date
    Mar 2002
    Posts
    534
    1) You create a table with all zip codes related cities, states and countries
    2) You check you new zip code against this table. The way how it is checked can be done by 1001 ways depending for what you need it, why you need it....

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    I would bet the farm this wheel has already been invented and that the USPS has the data available in several database formats. Are you planning on entering every zip code in the US along with the city name and state? Can I watch?

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You need a third-party product to do this -- start with USPS. Zip codes do not map easily to cities or counties (nor even to states, I think) and you end up with many-to-many matches.

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Originally posted by stecal
    I would bet the farm this wheel has already been invented and that the USPS has the data available in several database formats. Are you planning on entering every zip code in the US along with the city name and state? Can I watch?
    Personally I can think of better things to watch than this.

    Yes, you can get the data directly from the USPS. You can also contact a company based in LaCrosse, WI called First Logic. They have a third party tool that will take either a dbIII, CSV or a fiixed length file and do the following: Cleanup and verify the addresses, including checking zip codes with cities, adding the plus 4, standardizing business names, do a merge sort of the names and addresses, the list goes on. The product is pretty good, although their gui is slightly flaky. but like Stecal said why reinvent the wheel. Especially since a third party tool will keep updating their product and send you new USPS data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width