CASE in WHERE + condition

[RhythmAddict112]

Hey SQL Gurus,
Not sure if I'm just "not all there" today, or what...but here is the Q. I need to do a case statement in my where clause, this works:

WHERE r.[SomeCol] = @SomeColVal
AND SomeOtherCol =  
(
CASE WHEN (@Year = 0 AND @Period = 0) THEN
@SomeVal
CASE WHEN...
...
CASE ELSE
@SomeVal
END

But I need an additional OR clause in my else block, ex:

WHERE r.[SomeCol] = @SomeColVal
AND SomeOtherCol =  
(
CASE WHEN (@Year = 0 AND @Period = 0) THEN
@SomeVal
CASE WHEN...
...
CASE ELSE
@SomeVal OR @SomeVal - 1
END

The above throws the following error:
Incorrect syntax near the keyword 'OR'. within the ELSE statement - not a surprise. I'm sure there is a workaround for this, but I just can't think of it right now. Any input would be great...thanks!

 

[markros]

WHERE r.[SomeCol] = @SomeColVal
AND (@SomeVal = -1 OR SomeOtherCol =
(
CASE WHEN (@Year = 0 AND @Period = 0) THEN
@SomeVal
CASE WHEN...
...
CASE ELSE
@SomeVal
END)

 

[bborissov]

WHERE r.[SomeCol] = @SomeColVal AND
      r.SomeOtherCol = CASE WHEN (@Year = 0 AND @Period = 0)
                                  THEN @SomeVal
                            WHEN...
                                  THEN ...

                            WHEN r.SomeOtherCol = @SomeVal - 1
                                 THEN @SomeVal - 1

                       ELSE @SomeVal 
                       END

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.