简单sql有关问题，给分50

简单sql问题，给分50
select id ,name from user where id in(1,3,2,4) 
sqlserver 查询结果默认按id asc 排序了
 我想不按照它默认排序且就按照我给的id顺序排序（1324）该怎么写？
标准sql的写法其他数据库也的适应

[解决办法]
select id ,name from user where id in(1,3,2,4)
order by charindex( ltrim(id) ,'1,3,2,4')
[解决办法]

SQL code

select id ，name from user where id in(1,3,2,4)  order by case when 1 then 1 when 3 then 2 when 2 then 3 when 4 then 4 end--try
[解决办法]
前后都加引号
避免1 12 这种。
SQL code
select id ,name from user where id in(1,3,2,4)   order by charindex( ','+ltrim(id)+',' ,',1,3,2,4,')
[解决办法]
SQL code
select name,number from master..spt_values  where number in(1,2,3,4) and type='p'order by case when number=1 then 1 when number=3 then 2 when number=2 then 3 when number=4 then 4 end/*name                                number----------------------------------- -----------NULL                                1NULL                                3NULL                                2NULL                                4(4 行受影响)*/
[解决办法]
select id ,name from user where id in(1,3,2,4)   order by (id+1)%2,id  

[解决办法]
SQL code
select   id ,name from [user] where id in(1,3,2,4)   order by charindex( ','+ltrim(id)+',' ,',1,3,2,4,')