我如何用一个SQL 语句把0表示为无，1表示为有

[lionqun]

同标题

[zwztu]

select case when columns1='0' then '无' else '有' end as columns1 from tablenames

[genny]

同意楼上的

select case when columns1='0' then '无'
when columns1='1' then '有'
else '其它情况'
end as columns1 from tablenames

[latahu]

SQL Server:
SELECT f1,f2,CASE f3 WHEN '0' THEN 'ok' WHEN '1' THEN 'no' WHEN '2' THEN 'okno' END , f4 FROM table1;
Oracle:
SELECT f1,f2,decode(f3,'0','ok','1','no','2','okno'), f4 FROM table1;

[szch]

Access数据库中如何使用