SELECT * FROM user_table WHERE id IN (11,333,244) ORDER BY CHARINDEX(CONVERT(VARCHAR(10),id),'244,11,333')