the code I pasted above but in reverse

no good, I've tried, is there anyone who can help me out with some code?

ok thanks, I'll give that a try

can you explain that to me? sorry but I'm very new to this

as far as I know it doesn't work in reverse, I have tried it without any success

thanks

in one of the reply's it said "If you had seen the @sql value just before executing it, you will know whats wrong." is there a way of...

thanks for the info, makes an interesting read

many thanks for the assistance, it works great now

What I posted wasn't the complete code, it was from a stored procedure which allowed me to specify the table name from vb code, I was testing it in the...

that's great, I've book marked that page for future reference, many thanks

many thanks for the help, using the IP address 127.0.0.1 didn't work, but using the servername did, although like you said a bit...