title: Sorting results on Oracle as ASCII
body: <p>I'm doing a query that returns a VARCHAR2 and some other fields. I'm ordering my results by this VARCHAR2 and having some problems related to the linguistic sort, as I discovered on Oracle documentation. For example:</p>
  
  <pre><code>SELECT id, my_varchar2 from my_table ORDER BY MY_VARCHAR2;
  </code></pre>
  
  <p>Will return:</p>
  
  <pre><code>ID     MY_VARCHAR2
  ------ -----------
   3648  A
   3649  B
   6504  C
   7317  D
   3647  0
  </code></pre>
  
  <p>I need it to return the string "0" as the first element on this sequence, as it would be comparing ASCII values. The string can have more than one character so I can't use the ascii function as it ignores any characters except for the first one.</p>
  
  <p>What's the best way to do this?</p>