Subject Re: [firebird-support] Condition in CASE statement
Author Mark Rotteveel
On Wed, 18 Jul 2012 09:20:59 -0000, "majstor" <majstoru@...> wrote:
> Hi,
> I have one small problem in CASE statement, I fount that CASE has IF
> structure and it can be IF some_value THEN.
> But I need to ask CASE statement IF some_field > some_value THEN or IF
> some_field BETWEEN some_value1 AND some_value2 THEN...
> Is this scenario possible in CASE statement or what can I use for this
> problem in my SQL statements?
> Thanks in advanced...

You can. See the 'Searched CASE' documentation: