title: Zip Code to City/State and vice-versa in a database?
body: <p>I'm new to SQL and relational databases and I have what I would imagine is a common problem.</p>
  
  <p>I'm making a website and when each user submits a post they have to provide a location in either a zip code or a City/State.</p>
  
  <p>What is the best practice for handling this?  Do I simply create a Zip Code and City and State table  and query against them or are there ready made solutions for handling this?</p>
  
  <p>I'm using SQL Server 2005 if it makes a difference.</p>
  
  <p>I need to be able to retrieve a zip code given a city/state or I need to be able to spit out the city state given a zip code.</p>