SQL server中自定义排序

select * from OrderPolicyDetail order by
(
    case Project 
        when 'C' then 1,
        when 'A' then 2,
        when 'D' then 3,
        when 'B' then 4
    else '' end
)     

当字段类别少时，可以利用case when排序字段