>>It should be select evaluate(lTableName) without quotes.
>
>That will give an error, it will be looking for lTableName as a variable then.
actually it should work with Select * from (lTableName), but (my mileage varied on this) may complain if the variable contains the table name with leading and/or trailing spaces. I know it complained in some situations, but didn't in some other, so I'd rather make sure it's trimmed before use.