--测试
declare @t table(num varchar(10))
insert @t select '111'
union all select '222'
union all select '333'
union all select '444'
union all select '000'
--查询
SELECT * FROM @t
WHERE num IN ('222', '333', '111')
order by charindex(num,'222,333,111')
SELECT * FROM @t
WHERE num IN ('222', '444', '111')
order by charindex(num,'222,444,111')