-- 错误写法,这样无法判断NULL值:
case field
when null then '1'
when 'A' then '2'
else '3'
end
-- 正确写法:
case
when field is null then '1'
when field = 'A' then '2'
else '3'
end
-- 或者:
case ISNULL(field,'')
when '' then '1'
when 'A' then '2'
else '3'
end
-- 错误写法,这样无法判断NULL值:
case field
when null then '1'
when 'A' then '2'
else '3'
end
-- 正确写法:
case
when field is null then '1'
when field = 'A' then '2'
else '3'
end
-- 或者:
case ISNULL(field,'')
when '' then '1'
when 'A' then '2'
else '3'
end