select a.hyj,a.HYZK,a.LSJ, (case when a.hyj>0 then cast(a.hyj as decimal(18,2)) when a.hyzk=95 then cast(a.lsj*0.95 as decimal(18,2)) else '暂无' end ) as 会员价 from yw_kck a order by 会员价报错如下:从数据类型 varchar 转换为 numeric 时出错表yw_kck
hyj hyzk lsj
10.00 0.00 15.00
9.5 95.00 9.00
0.00 0.00 25注:我就想让hyj和hyzk达不到case when 要求的,显示为暂无,不知可以吗?
hyj hyzk lsj
10.00 0.00 15.00
9.5 95.00 9.00
0.00 0.00 25注:我就想让hyj和hyzk达不到case when 要求的,显示为暂无,不知可以吗?
(case when a.hyj>0 then cast(cast(a.hyj as decimal(18,2)) AS varchar(20)) when a.hyzk=95 then cast(cast(a.lsj*0.95 as decimal(18,2)) AS varchar(20)) else '暂无' end ) as 会员价
from yw_kck a order by 会员价