sql语句将数字转为汉字展示
select [表字段Name] , ( case [表字段OrderState] when 1 then '已核销' when 2 then '确认前的移动端取消'when 3 then '已完成'when 4 then '已确认'when 5 then '已爽约'when 6 then 'pc端取消(联系上客户,时间未确定'when 8 then 'pc端取消(联系不上客户)'when 9 then '确认后的移动端取消' end) as [表字段OrderState] from 表名Demo