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;
3) EXECUTE STATEMENT.

--
SY, Dimitry Sibiryakov.