The answer

Hi AlmightyJu,

About 2 years later, I am seeing your question because I was looking for the same answer.
The answer is:

Code:
SELECT *
FROM tmptbl
WHERE id IN (5,10,14,1)
ORDER BY CHARINDEX(','+CONVERT(varchar, tmptbl.id)+',', ',5,10,14,1,')
You probably notice the extra commas (,) in the charindex function. Without those, the id "1" would become the 2nd...