title: What is the difference in mysql BETWEEN OPERATOR and microsoft sql (MDB) BETWEEN OPERATOR
body: <p>I have a table in mysql and sql with field name called zipcode (datatype TEXT), and both tables total records are same, if I run the between query</p>
  
  <pre><code>select zipcode 
  from tablename 
  where zipcode between '7895154245' to '9545781543'
  </code></pre>
  
  <p>in mysql and sql the result which I am getting is missmatched. Please let me know the how to match the both results.</p>