My query is as follows:
SELECT STRINGTEXT, TOKENID
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!!
Sorry for my rant, but its got my hot under the collar.
Is there anyway round this?