title: how to query get max id from varchar type?
body: <p>i have table and column varchar type column id
  and values are m1, m2, ... , m9,m10,m11,m12
  then i use query </p>
  
  <blockquote>
    <p>select MAX(id) from table</p>
  </blockquote>
  
  <p>but the result as m9 because it consider m10 as 'm','1','0' as an individual characters.so m9>m1(0).</p>
  
  <p>Please help ?how to query get max id from varchar type ?</p>