title: SQL Order Alphabetically without preceding zeros for numbers less than 10
body: <p>Is it possible to order alphabetically in mySQL in the following fashion:</p>
  
  <p>A1<br>
  A2<br>
  A3<br>
  A5<br>
  A10<br>
  A11<br>
  A20<br>
  A23<br>
  A24  </p>
  
  <p>Unfortunately the order that I am getting is ordered as seen below here.  Notice how any number before A10 aren't grouped together?</p>
  
  <p>A1<br>
  A10<br>
  A11<br>
  A12<br>
  A2   &lt; A2<br>
  A20<br>
  A23<br>
  A24<br>
  A3  &lt; A3<br>
  A5  &lt; A5  </p>
  
  <p>Note:
  These alphanumeric strings are actually postal codes, so I cannot put A01, because that's not technically a postal code prefix.  I would also like to avoid having the user to enter in other data to help the system sort it properly, because my users aren't very web savvy.  Also, these alphanumeric strings will not be able to be input into the database in the correct order because they can be deleted and added at anytime.</p>