Re: Can I use a variable for a column or table name

David Gress wrote: > > In informix 7.3 on UNIX i want to do the following in the Stored Procedure > Language: > create procedure test( colName varchar(18))> > select colName from customers into temp temp1;> > end procedure; > > then run > > execute procedure test(customer_name); Check to Jonathan's reply. However, you could have the stored procedure create a procedure to select the named column then execute it then drop the procedure. It is the only way to simulate dynamic SQL in SPL. Art S. Kagel