title: T-SQL ORDER BY number and letters mixed in string
body: <p>I have a range of <strong>unique</strong> strings which contain numbers and sometimes numbers and a letter, a sample of which reads:</p>
  
  <ul>
  <li>1X</li>
  <li>2X</li>
  <li>2Y</li>
  <li>12X</li>
  <li>20</li>
  <li>21</li>
  </ul>
  
  <p>The number/s always precede the letter. What is the ORDER BY (T-SQL) clause solution to produce a list which would give me the order as demonstrated above?</p>
  
  <p>I tried using</p>
  
  <p>LEN(<em>fieldName</em>), <em>fieldname</em> - which would work but for the 20 and 21. I have tried expressing the strings as an integer but the CAST fails in the conversion process.</p>