select case re when is null then 'a' else re end as 're' from visit
温馨提示------开帖请结帖create table visit(re varchar(10)) insert visit values(null) insert visit values('abc')select case when re is null then 'a' else re end as 're' from visitdrop table visit
select case when re is null then 'a' else re end as 're' from visit
SELECT CASE WHEN ISNULL(SATEE,NULL) THEN 'A' ELSE STATE END AS FROM TABLE
insert visit values(null)
insert visit values('abc')select case when re is null then 'a' else re end as 're' from visitdrop table visit