求一条查询语句。。。。。。

[davcsevil]

我想实现这样式效果：
select a.id as aid,a.type as aaaa form a


在红色部分加一条判断语句，如果a.type结果为Q，则结果aaaa输出"是" 如果a.type结果为F，则结果aaaa就换成"否"

不能用字符串替换语句

[shenzhenNBA]

修改。。。

select a.id as aid,(case a.type when 'Q' then '是' when 'F' then '否' end) as [确认状态] form a 

[一把编程的菜刀]

[Quote=引用 1 楼 shenzhennba 的回复:]
修改。。。
SQL codeselect a.idas aid,(case a.typewhen'Q'then'是'when'F'then'否'end)as[确认状态] form a

[/Quote]

这个是MSSQSL的写法

如果是ACCESS的要换用IIF

[hookee]

select a.id as aid, CASE a.type WHEN 'Q' THEN '是' WHEN 'F' THEN '否' END from a

[一把编程的菜刀]

mssql

select a.id as aid,(case a.type when 'Q' then '是' when 'F' then '否' end) as flag form a 

ACCESS:

select a.id as aid,IIf(a.type='Q','是','否') AS flag from a