Hey.. sorry its taken a while to reply I had to figure out adding watches to packages (I wasn’t kidding when I said I was new to this!)…

The variable almost...

here you go...

here you go...

As requested... if any other boxes would be useful.. let me know.

Thanks!

That was one of the first thing I tried but all those boxes are still coming up red!

Its a different error message when replacing the '0' with a '?' in...

Thanks for your reply... i've spent sometime looking up using dynamic sql to create tables and have it working ok in management studio but can't seem to get it working...

What you're saying makes perfect sense but I'm struggling to figure out how to do it!

How do you select a substring of the variable and what sql syntax do...