title: Using UNION with ORDER BY does not produce expected results in Sybase
body: <p>I have a list of Currencies E.g, USD, AED, INR, EUR, GBP (in order of entry in table Currencies). I need to prepare a query with all currencies including 'ALL' as well but sorted with 'ALL' appearing as the first one.</p>
  
  <p>Expected result should be in the following order:</p>
  
  <pre><code>ALL
  AED
  EUR
  GBP
  INR
  USD
  </code></pre>
  
  <p>My SQL is:</p>
  
  <pre><code>SELECT 'ALL' Currency
  UNION ALL
  SELECT Currency FROM Currencies ORDER BY Currency
  </code></pre>
  
  <p>However, the above SQL produces with AED as the first one due to sorting.</p>
  
  <pre><code>AED
  ALL
  EUR
  GBP
  INR
  USD
  </code></pre>
  
  <p>Help appreciated to get 'ALL' on top.</p>