IF in WHERE clause

[griffitd]

Hi

Wnat i want to do is the following

WHERE
IF Table1.date1 is null then
table2.date2 between @FirstDate AND @LastDate
else
table1.date2 between @FirstDate AND @LastDate

Thanks in advance

 

[markros]

You may use case based where, e.g.

case when Table1.Date1 is NULL then Table2.Date2
ELSE Table1.Date2 end BETWEEN @FirstDate and @LastDate

PluralSight Learning Library

 

[griffitd]

That workis a treat

Thanks