在sql语句中怎么样使用iif函数？

[truesmx]

在sql语句中怎么样使用iif函数？

select b.ID,a.src_terminal_id,convert(varchar(255),b.msg_content) as content,
a.House_Number,a.Flag,b.ih_timestamp from SHQ_note as a INNER JOIN cm as b
on a.upid=b.id where DATEDIFF(Day,b.ih_timestamp,getdate())<=10 AND IIF(LEFT(a.src_terminal_id,2)='86',SUBSTRING(a.src_terminal_id,3,3),LEFT(a.src_terminal_id,3))>=100
order by b.id desc
说有错误，是不是iif函数有问题？

[Andy__Huang]

sql server2000里沒有iif()函數﹐它用case when ....then ....end代替

[Andy__Huang]

select b.ID,a.src_terminal_id,convert(varchar(255),b.msg_content) as content,
a.House_Number,a.Flag,b.ih_timestamp
from SHQ_note as a
INNER JOIN cm as b
on a.upid=b.id
where DATEDIFF(Day,b.ih_timestamp,getdate())<=10
AND (case when LEFT(a.src_terminal_id,2)='86' then SUBSTRING(a.src_terminal_id,3,3) else LEFT(a.src_terminal_id,3) end)>=100
order by b.id desc

[hhgb]

使用
case when 条件 then 处理 else 处理 end

[tinghuyang]

up