sql-server-2005 - 在Where子句中使用if语句

Question

是否可以在where子句中使用if语句？

即

WHERE (underwritername = 'underwriter')
and (case when inceptiondate is null then
(requestdate >= convert(datetime,'01/10/2009',103))
else
(Inceptiondate >= convert(datetime,'01/10/2009',103))
)
and (requestdate <= convert(datetime,'31/10/2010',103))

基本上，如果一列为空，我需要使用替代列进行选择。

非常感谢，

亚当

Answer 1

您可以使用稍微不同的 CASE 语句来做到这一点:

WHERE (underwritername = 'underwriter') 
and (case when inceptiondate is null 
     AND requestdate >= convert(datetime,'01/10/2009',103) THEN 1 
     WHEN inceptiondate IS NOT NULL 
     AND Inceptiondate >= convert(datetime,'01/10/2009',103) THEN 1 ELSE 0 END = 1) 
and (requestdate <= convert(datetime,'31/10/2010',103))