Selective Comparisonv In Where Clause

I was trying to use the case statement in where clause so that the comparison (> , <, =) can be made depending upon the value of the local variable @fl.



PLease tell me how to do that. Or suggest me how can I make selective comparison (<,>,=) in where clause depending upon a local variable. Please note that I donot want to use if/else satement and write select statement everytime based on the local variable as in that case the code length will be huge. Please suggest me a coensized query.


SQL that I queried:

use pubs
go

declare @fl int

select fl = 3

select * from titles
where case fl when 1 then price > 90
when 2 then price < 90
when 3 then price = 90
end

The following error is given

Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '>'.