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