Subject Re: [firebird-support] Question select in Stored procs
Author Dimitry Sibiryakov
On 14 Jan 2006 at 10:42, Erik De Laet wrote:

>I want to select different fields of a table
>depending on a parameter to the stored procedure.
>Is this possible ?

Yes. Three solution (from the best to the worst):

1) CASE expression;
2) Select both fields into local variables and then use IF to assign
one of them to the returning parameter;

SY, Dimitry Sibiryakov.