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