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

THEN

> 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:
http://www.firebirdsql.org/refdocs/langrefupd25-case.html#langrefupd25-case-searched

Mark