martinknappe wrote:

> hi,
> i'm looking for a way to create an sp or a udf that looks sort of like
> the following:
>
> variableselect(field, table)
> begin
> select :field from :table;
> suspend;
> end
>
>
> so a call to variableselect(custNo, customers) would do
>
> select custNo from customers;
>
> is there a way to accomplish something like that??
>

Probably not, unless you read up on the EXECUTE statement.

--
Aage J.