例如:
select case FieldA when '1 ' then '是 '
else Case FieldB when '1 ' then '是 '
else '否 '
end as ddd from tableA
------解决方案--------------------
select
case FieldA
when '1 ' then '是 '
else
Case FieldB
when '1 ' then '是 '
else '否 '
end
end as ddd from tableA