title: SQL Order by DESC on alphanumeric field with numbers before words
body: <p>I have a column in a SQL table I'm trying to do an order by on. The data needs to be in desc so it shows more recent years first.</p>
  
  <pre><code>Sample Data         Expect Output
  -----------         -------------
  older                   2013
  2012                    2012
  2013                    2011
  2011                    older
  </code></pre>
  
  <p>Using this particular method I only have access to the <code>Order by</code> and <code>WHERE</code> clauses rather than full blown SQL.</p>
  
  <p>This limits me from being able to pull the data out in 2 sets and joining.
  I also can not manipulate the <code>older</code> field to something like <code>999order</code> and strip the <code>999</code> out later.</p>
  
  <p>Is there a way to order by that will give me what I'm looking for?</p>