Any idea, please?

[Lafor]

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.

[Lafor]

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