>> Can someone tell me if there is a limit about the amount of 'when' conditions in a case expressions, like in the 'in' statement?
>
> I haven't tried. ;-)
>
> One limit you have for sure is ~64K for the CREATE DDL statement and
> AFAIK ~48K for the compiled BLR.

Ah, forgot the above. I misread your question and thought you are asking
about exception handling in BLR.

> Is your question theoretical for some kind of case study or DBMS
> comparison thingy or did you hit a limit already? Just curious. ;-)
>
>

--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/