sqlserver 按照特定值排序查询结果

select * from t_ss_student
order by case when xm like '林%' then 1 else 2 end asc; 姓林的会排在前面