> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer<ts@...> wrote:
>> Is your question theoretical for some kind of case study or DBMS
>> comparison thingy or did you hit a limit already? Just curious. ;-)
>
> In really, is a practical question.
>
> I have to classify some records (about 300k) in many categories (nearly 200). So, I thought do this directly in the select statement (using case clause). However, write a query with 200 conditions "when ... then..." to, at the end, the debugger tell you that you reached the conditions limits is kind annoying.

I would rather create a mapping/lookup table and join the two tables.


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

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/