Hi Daniel,

Many thanks for your reply.

I was using an Execute SQL within the For Each Loop.

Could you please give an example of the 'variable to build your entire SQL Statement'. I am not sure of how to progress with the actual statement. If you could provide some guidance I would be most grateful.