title: SQL for ordering by number
body: <p>I'm attempting to order by a number column in my database which has values 0-1000 and includes decimal numbers.</p>
  <p>When I use</p>
  <pre><code>ORDER BY len([FY14 Points]), [FY14 Points]
  </code></pre>
  <p>I get...</p>
  <pre><code>0
  48
  150
  249
  36.9
  39.7
  44.5
  52.5
  54.4
  57.9
  58.4
  60.1
  </code></pre>
  <p>I've also tried...</p>
  <p><code>ORDER BY registration_no * 1 ASC</code></p>
  <p>But get this...</p>
  <blockquote>
  <p>Msg 245, Level 16, State 1, Line 6</p>
  <p>Conversion failed when converting the varchar value '88.4' to data type int.</p>
  </blockquote>
  <p>Does anyone know what I can do to get around this?</p>