数据库中加条件判断来决定显示的数值-数据库专栏,SQL Server

select jxc_yj_xzwz.clmc as 物资名称, jxc_yj_xzwz.ggxh as 规格型号,
      cast(jxc_yj_xzwz.sl as int) as 数量, isnull(scdwbmk.dwmc, ) as 所属部门,
      case jxc_yj_xzwz.syqk when 0 then 未使用 else 使用 end as 使用情况,
      substring(convert(varchar, jxc_yj_xzwz.rq, 20), 1, 10) as 制造日期,
      jxc_yj_xzwz.zdr as 制单人, jxc_yj_xzwz.bz as 备注
from jxc_yj_xzwz left outer join
      scdwbmk on jxc_yj_xzwz.bmbm = scdwbmk.dwbm