Nice one Jeffrey - that's spot on.

Many thanks for your help on this one.

Nigel.

Thanks for your input on this guys, I've not explained what I want very well though so here goes a 'proper' post!

I'm concerned with two tables created as follows:

IF OBJECT_ID('TempDB..#propval','U')...