Rod

I'm assuming that you mean you want to put the table name into the SQL dynamically, i.e. you don't know its name at programming time. OK so you have your table name stored in the string lcMyTableName. You can use a "named expression", i.e:

Select * from ( lcMyTableName) into ...

Is this what you're after?

Terry

>Hi
>I have a select sql instruction, and I want to extract a string with the table names.
>¿There is any object, function, procedure with this functionality?
>TIA