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

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/