Hi,

At May 8, 2003, 07:37, Thomas Steinmaurer wrote:

>> > 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 must have missed something then, because the release notes indicate
only usage in SELECT. So, you can use CASE instead of IF in PSQL.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)