title: SQL - Order By Function for a1,a2,a3,a4...a101
body: <p>I'm new to SQL and running into difficulty.</p>
  
  <p>If I have a column A1,A2,A3...A1000</p>
  
  <p>When I order by this column, it appears A1,A100,A2... I get the logic why.</p>
  
  <p>ATTEMPT: <code>order by left(length(company.company_code),-1) ASC;</code></p>
  
  <p>I attempted the above to try cut away the A but no luck?</p>
  
  <p>Any advice?</p>