On Wed, 07 Mar 2012 11:34:09 -0000, "Cristiano" <boxferrari@...>
wrote:

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

Is it a straight forward WHEN field = <exact value> THEN <other exact
value>? If so, consider using a helper-table and join against that instead
of using a CASE.

Mark