title: Sql order by ascending, some values are not in acending order
body: <p>I have an SQL statement that orders the table in ascending order via the id, but when I do this, the table shows it like:</p>
  
  <pre><code>c-10
  c-12
  c-12
  c-24
  c-5
  c-6
  c-80
  c-800
  c-8000
  </code></pre>
  
  <p>As this shows that the top few and bottom few are in order but not the other part. Why is this? As I have tried ordering by my other fields in the table and they appear fine, it's just this column. Do you think this could be an input error or something else? </p>
  
  <p>Many thanks for your help!</p>