Change where clause upon some condition in a single select statement

[itsmeyogi]

Hi
I have a problem where i want to change the select statement where clause upon a condition

declare @finyr int
select @finyr = 2002
select acct_no
from acct_mast
where case when month(deposit_dt) > 3
then (year(deposit_dt) + 1) >= @finyr
else year(deposit_dt) >= @finyr
end
This query doesn't work !!!!!!!

Thanx in advance!!!!

 

[tlbroadbent]

In order for the WHERE clause to work, yo must name a column and then define the criteria using the CASE statement. The following should work.

where year(deposit_dt) >=
case
when month(deposit_dt) > 3
then @finyr-1
else @finyr
end
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.