Here is the situation that I am trying to solve:

I have a query that could return a set of records. The field being sorted by could have a number of different values - for the sake of this question we will say that the value could be A, B, C, D, E or Z

Now depending on the results of the query, the sorting needs to behave as follows:
If only A-E records are found then sorting them "naturally" is okay. But if a Z record is in the results, then it needs to be the first result in the query, but the rest of the records should be in "natural" sort order.

For instance, if A C D are found, then the result should be

```
A
C
D

```

But if A B D E Z are found then the result should be sorted:

```
Z
A
B
D
E

```

Currently, the query looks like:

```
SELECT NAME, SOME_OTHER_FIELDS FROM TABLE ORDER BY NAME

```

I know I can code a sort function to do what I want, but because of how I am using the results, I can't seem to use because the results are being handled by a third party library, to which I am just passing the SQL query. It is then processing the results, and there seems to be no hooks for me to sort the results and just pass the results to the library. It needs to do the SQL query itself, and I have no access to the source code of the library.

So for all of you SQL gurus out there, can you provide a query for me that will do what I want?