Thanks Gail, works perfectly now.

Yes, i didn't think that was right. So do you have any idea as to why the @sql will not execute but by cutting, pasting and executing the printed @sql...

I thought thats where you meant, can you give an example? when i've added a SELECT name to just before the FROM it doesn't work.

Thanks

Thanks but where would you put the SELECT in?