SQL Ordering and Adding a Row
<p>Here's my SQL code:</p>

<pre><code>SELECT DISTINCT 
    CASE 
       WHEN RS != '' 
          THEN RS 
          ELSE 'Unspecified RS' 
    END AS 'RS Name'
FROM 
    OutstandingClaims
</code></pre>

<p>It'll return</p>

<pre><code>Alexa
Bob
Cary
Dylan
...
Unspecified RS
...
etc.
</code></pre>

<p>I want to have the entry "All" at the top of this list. Is there a way I can do that without renaming people?</p>