Thanks both for your help!!

BO

Ignore my last message, I'm being an idiot as usual...

Cheers for this. I actually got it the wrong way round though!!

The table with the multiplication signs round the REGION does not have the extra text its the other table...

These solutions are both great guys - thanks so much!!

One other thing, what if the region in Table2 did not only have multiplication (star) signs either side but also other...

Cheers for the quick update...

Actually they are stars * rather than quotes "" Tried the same logic but it didn't seem to like it - no error but no join...

Sorry I should have said, I adapted the code a little but actually as you've indicated it didn't make sense to do so!

I'm going with the original (correct and working)...

One problem.

I want to sum the PlannedSales then multiply by the factor increase. However I'm getting an error which says I can't have an aggregate in an update statement....

Cheers Sean for your quick response on this...

Looks good, I'll give it a try..

Thanks again.

Thanks Lynn - this is perfect!!!

BO

Thank you too Lynn!

Eugene

Thanks for this, really helpful.

BO

Thanks Nigel - just what I was after!

BO

Cheers Rob

That's the pointer I needed!

BO

Cheers guys.

I will need to run this going forward so the SSIS suggestions look like they'll do the job.

Thanks again.

Cheers Daniel

Looks good.

Thanks for your help.