select case
when 1=1 then 'Y'
else 'N'
end
as column_a
select case 'affasn'
when '1' then 'a1'
when '2' then 'a2'
else 'a3'
end
as column_b
select case
when 1=1 then 'Y'
else 'N'
end
as column_a
select case 'affasn'
when '1' then 'a1'
when '2' then 'a2'
else 'a3'
end
as column_b