title: SQL Oracle Sort string (numbers) and (letters with numbers)
body: <p>I am new to oracle and I have a problem. 
  I have a column named file_id. </p>
  
  <p>When I do an order by it sorts strings such as </p>
  
  <pre><code>1
  1 
  10 
  100 
  11 
  11
  110 
  114
  12
  300 
  31
  4200
  B14
  B170
  B18
  </code></pre>
  
  <p>edit:
  I would like it to sort this way. </p>
  
  <pre><code>1
  1
  10
  11
  11
  12
  31
  100
  300
  4200
  B14
  B18 
  B170
  </code></pre>
  
  <p>The answer below works perfectly. Only other problem  I  ran into now..I have records that are blank. How could I make the blank records order at the end? </p>
  
  <pre><code>1 
  1 
  10 
  11 
  11 
  12 
  31 
  100 
  300 
  4200 
  BLANK 
  BLANK 
  BLANK 
  BLANK 
  BLANK 
  B14 
  B18 
  B170
  </code></pre>
  
  <p>Thank you for your help.</p>