Thank you Charlie,

In this case I got a good answer from Sergey and Kevin but I am going to use your suggestion in other areas as I have quite a lot of complex SQLstatements and was going to the "very Boring" route of concatenating every one of them. Your suggestion will save me a lot of time in the future.

Thanks again

Brendan