> I can not seem to get the case statement to work inside a stored procedure.
>
> Am I missing something ?

Firebird does not support case statement, only case expression.

Ivan