请问以下这段SQL该怎么写，要达到的目的，把表中某一列显示为0.00的替换显示成‘-’其他不变，

Question

select BudgetMoney,YFJMoney(when (YFJMoney = 0.00) then '-' end ) from Z_HNJT_YS_BudgetYear
是替换显示，不是Update哦，谢谢

Answer 1

可以用case 语句来实现

select BudgetMoney,case when YFJMoney = 0.00 then '-' else cast(YFJMoney as varchar(10) end as YFJMoney from Z_HNJT_YS_BudgetYear