title: SQL Server 2012: Incorrect syntax near the keyword 'order'
body: <p>I get this error when running this query...</p>
  
  <pre><code>select *, stuff(PartNumber,1,3,'') 
  from products.products 
  where  isnumeric(stuff(partNumber,1,3,'') 
  order by cast(Stuff(partNumber,1,3,'')As Float)
  </code></pre>
  
  <p>Any ideas?</p>
  
  <p>Thanks!</p>