Re: Functions with dynamic queries

I guess the examples on standard docs explain it.
dont they?

>
>     A very simple case would be:
>
> Create table people (
>     nif    char(12),
>     name    varchar(40),
>     primary (nif)
> );
>
> And now to create a function to return "name" value giving
> "nif" values as a parameter.

you may not need a function at all if your case is that simple . you
can use subselects and || operators to do many complicated things..
can we know a bit more abt. your specific problem

regds
,--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.