select distinct case ISNULL( j_address,'空值') when '空值' then '字段不为空' else '' end as 家庭地址
from j_abroad ja WHERE ja.j_address IS NULL
SELECT distinct ISNULL( j_address,'字段不为空') 家庭地址 from j_abroad ja WHERE ja.j_address IS NULL
结果图如下:
select distinct case ISNULL( j_address,'空值') when '空值' then '字段不为空' else '' end as 家庭地址
from j_abroad ja WHERE ja.j_address IS NULL
SELECT distinct ISNULL( j_address,'字段不为空') 家庭地址 from j_abroad ja WHERE ja.j_address IS NULL
结果图如下: