help!! How to set tablename variable?

hi everybody,

say i want to pass a tablename variable (v_tblname) into a stored procedure to perform a sql statement.
Inside my stored proc i wrote:

select * from v_tblname;

but i always encountered errors. so i just want to know that is there a way to set a table name as a variable? if yes, how?

yr helf would be greatly appreciated!! thanks!!

lkw. Received on Thu Dec 16 1999 - 00:33:21 CST