Hi all,

Given the query

SELECT SomeNumber, Name
FROM SomeTable
WHERE SomeNumber IN (5, 4, 3, 2, 1, 81, 80, 79, 78, 77)

I want the records to be returned in the same order that they are
specified in the WHERE..IN clause.

Is there a way to do this?

As it stands, they are coming in ascending order,
1,2,3,4,5,77,78,79,80,81. Descending is no good because that will be
81,80,79,78,77,5,4,3,2,1.





Simon