sqlserver 替换数字类型的null和0数据为斜杠
SELECT 字段名,字段名,
case when CAST(字段名 AS VARCHAR) =‘0’ then ‘/’ when CAST(字段名 AS VARCHAR) IS NULL then ‘/’ else CAST(字段名 AS VARCHAR) end as 字段名,
case when CAST(字段名 AS VARCHAR) =‘0’ then ‘/’ when CAST(字段名 AS VARCHAR) IS NULL then ‘/’ else CAST(字段名 AS VARCHAR) end as 字段名,
case when CAST(字段名 AS VARCHAR) =‘0.00’ then ‘/’ when CAST(字段名 AS VARCHAR) IS NULL then ‘/’ else CAST(字段名 AS VARCHAR) end as 字段名,
case when CAST(字段名 AS VARCHAR) =‘0.00’ then ‘/’ when CAST(字段名 AS VARCHAR) IS NULL then ‘/’ else CAST(字段名 AS VARCHAR) end as 字段名,
case when CAST(字段名 AS VARCHAR) =‘0’ then ‘/’ when CAST(字段名 AS VARCHAR) IS NULL then ‘/’ else CAST(字段名 AS VARCHAR) end as 字段名,
字段名,字段名,字段名
FROM 表名 WHERE 字段名 LIKE ‘%%’ AND 字段名 LIKE ‘%%’ AND 字段名 LIKE ‘%%’