Subject Re: [firebird-support] create a stored procedure
Author Markus Ostenried
At 17:09 Friday, 15.10.2004 -0600, Rick Roen wrote:
>I'm trying to write a stored procedure to return a conversion from "x" into
>pounds to be eventually used in converting amounts in a Select.
>Can anyone help?

Hi Rick,

I think the CASE syntax is only valid in SELECT statements.
In stored procs you have to use multiple IF .. THEN .. ELSE