Hi

I have the following query

Code:
SELECT [eventid], [name],[date] FROM events WHERE eventid IN(22,13,18)
I'd like to ensure the records are returned sorted by the eventid in the order the eventid's appear in the IN statement.

EG:

22 | Event ABC | 28/09/2012
13 | Event XYZ | 12/08/2012
18 | Event CDE | 22/09/2012

Is this possible?