title: Sort dropdown list in Alpha Numeric order
body: <p>I have an asp dropdown list control, databound to a sql database. The values it receives look like this:</p>
  
  <pre><code>S1
  S10
  S10A
  S10B
  S10C
  S1A
  S1B
  S1C
  S1D
  </code></pre>
  
  <p>But i need it to sort by alpha first, then numeric but to include the last letter (if there is one). So the output should look like this:</p>
  
  <pre><code>S1
  S1A
  S1B
  S1C
  S1D
  S10
  S10A
  S10B
  S10C
  </code></pre>
  
  <p>I can do an ORDER BY in the select statement but that doesn't solve the problem.</p>