sql server 让字段根据指定意图排序

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