I am trying to send the table name to my stored procedure, which looks something like this;<BR><BR>Select Name from [@Table_Name] where ID = X<BR><BR>My problem is it doesn&#039t seem to pass the table name correctly.<BR>All my other stored procedures work where I pass the value of a field, so my question is....<BR><BR>Can you even do this with the table name or is it just the values you can pass?<BR><BR>Thanks for any help<BR><BR>Ed<BR>eddyboy@btinternet.com