title: Selecting zipcode that is stored in string as numberic range (hive)
body: <p>I'd like to select people who live in california zipcodes. However this table i'm using stores zipcodes as string, instead of integers, so I havre to put a qutoe around it. </p>
  
  <p>How can I select these values in range, instead of having to type it out? 
  I'd like to do something like this: 
  <code>select people from tablename where postal_code &gt;= '90001' and postal_code &lt;= '96162'</code> </p>
  
  <p>Thank you!</p>