> SELECT STRINGTEXT, TOKENID
> FROM WEBSTRINGS
> WHERE TOKENID IN (6,20,234,19,32,4,800,177)
>
> All I want is my resultset to come back in the order that I have defined
> in
> the IN clause, but unfortunately SQL is trying to be too helpful and sorts
> the numbers in the IN clause so that the resultset comes back with a
> TOKENID
> order of 4,6,19,20,32,177,234,800.
>
> I don't want this bloody order I want 6,20,234,19,32,4,800,177!!

Far from elegant:

SELECT STRINGTEXT, TOKENID
FROM WEBSTRINGS
WHERE TOKENID IN (6,20,234,19,32,4,800,177)
ORDER BY
TOKENID=6 DESC,
TOKENID=20 DESC,
TOKENID=234 DESC
TOKENID=19 DESC,
TOKENID=32 DESC,
TOKENID=4 DESC,
TOKENID=800 DESC,
TOKENID=177 DESC;


Regards
Dimitre