select * from 表 t where 字段名 in ('1','2','3')order by charindex(','+convert(varchar,字段名)+',','1,2,3,')