Any idea, please?

I need to do something like this

select @string = 'My table'
CREATE TABLE @string (vchasd varchar(10) null,
vchfg int null)

where @string is a variable

Has any 1 ever done this?
Can it be done?

Thanks in advance

This string variable will be passed to a stored procedure
as an argument

My understanding of your problem is that you want to run a stored procedure with a stringargument, isn't it?

If yes, U have 2 ways:

-> easy

cn.execute "exec Storedprocedurename '"& vbvar & "'"
that will execute e.g. the following SQL statement:

exec storedprocedurename 'blablabla'
(don't forget the single quotes!
-> annoy me

create a command object, an parameters collection in that command object, populate your argument and execute the command.

franckly, the easy is the best on my mind.

Hope that help.

Thanks for responding...

I did describe my intents.. poorly

But I did find a way to solve what I wanted to....do

Thanks again for responding VBGURU