Hi,

> > > Does FB support SQL CASE statements?
> >
> > CASE statements in SELECT, yes. CASE statements as a structure in
> > stored procedures, no.
>
> Are you sure? CASE in Firebird 1.5 PSQL works for me.

I guess Daniel meant :

CASE TableA.FieldX
'BLA1' : BEGIN
<procedure_statement_block>
END
'BLA2' : BEGIN
<procedure_statement_block>
END
ELSE BEGIN

<procedure_statement_block>
END
END

and this isn't possible


Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81