<p>I have a PHP application that displays a list of options to a user.  The list is generated from a simple query against SQL 2000.  What I would like to do is have a specific option at the top of the list, and then have the remaining options sorted alphabetically.</p>

<p>For example, here's the options if sorted alphabetically:  </p>

<pre><code>Calgary  
Edmonton  
Halifax  
Montreal  
Toronto  
</code></pre>

<p>What I would like the list to be is more like this:  </p>

<pre><code>**Montreal**  
Calgary  
Edmonton  
Halifax  
Toronto  
</code></pre>

<p>Is there a way that I can do this using a single query?  Or am I stuck running the query twice and appending the results?</p>

```
```
SELECT name FROM options ORDER BY name = "Montreal", name;
```
```
Note: This works with MySQL, not SQL 2000 like the OP requested.