title: SQL for ordering by number - 1,2,3,4 etc instead of 1,10,11,12
body: <p>I’m attempting to order by a number column in my database which has values 1-999</p>
  
  <p>When I use </p>
  
  <pre><code>ORDER_BY registration_no ASC
  </code></pre>
  
  <p>I get….</p>
  
  <pre><code>1
  101
  102
  103
  104
  105
  106
  107
  108
  109
  11
  110
  Etc…
  </code></pre>
  
  <p>So it appears to be ordering by the first digit as oppose to the number.</p>
  
  <p>Does anyone know what SQL to use if I want to order this by value? So <code>1,2,3,4,5,6</code> etc </p>