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...