Look up help on EXECUTE STATEMENT. This is what you will need to do what you want.

Jason

willogibbo wrote:

> Hi everyone
>
> Is it possible to pass variables into a stored procedure that can be
> used as the names of fields or tables, so that the same stored
> procedure can effectively be used on different tables?
>
> Maybe it is possible to put together sql strings in a stored procedure
> that can then somehow be executed in the procedure itself?
>
> Any thoughts on this would be greatly appreciated.
> Thanks
> Will
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.