title: Sorting VARCHAR column with alphanumeric entries
body: <p>I am using SQL Server, the column is a <code>VARCHAR(50)</code> and I want to sort it like this:</p>
  
  <pre><code>1A        
  1B        
  2        
  2        
  3        
  4A        
  4B        
  4C        
  5A        
  5B        
  5C        
  5N        
  14 Draft        
  21        
  22A        
  22B        
  23A        
  23B        
  23C        
  23D        
  23E        
  25        
  26        
  FR01584        
  MISC
  </code></pre>
  
  <p>What I have so far is: </p>
  
  <pre><code>Select *
  From viewASD
  ORDER BY 
      Case When IsNumeric(LEFT(asdNumNew,1)) = 1 
           Then CASE When IsNumeric(asdNumNew) = 1 
                     Then Right(Replicate('0',20) + asdNumNew + '0', 20)
                     Else Right(Replicate('0',20) + asdNumNew, 20) 
                END
           When IsNumeric(LEFT(asdNumNew,1)) = 0 
           Then Left(asdNumNew + Replicate('',21), 20)
      End
  </code></pre>
  
  <p>But this SQL statement puts '14 Draft' right after '26'.</p>
  
  <p>Could someone help? Thanks</p>