title: Order by last 2 characters string
body: <p>This is the result of my query, but it doesn't order correctly. I want to order by the last 2 characters. The result should be: <code>Fa0/10</code> below <code>Fa0/9</code>.</p>
  
  <pre><code>Fa0/1
  Fa0/10
  Fa0/11
  Fa0/12
  Fa0/2
  Fa0/3
  Fa0/4
  Fa0/5
  Fa0/6
  Fa0/7
  Fa0/8
  Fa0/9
  Gi0/1
  Gi0/2
  Null0
  Vlan1
  </code></pre>
  
  <p>My query:</p>
  
  <pre><code>SELECT inft.port FROM interfaces AS intf ORDER BY RIGHT(intf.port + 0, 2)
  </code></pre>
  
  <p>Second: <a href="http://sqlfiddle.com/#!2/fde72/5" rel="nofollow noreferrer" title="sqlFiddle">sqlfiddle</a></p>