Agreed. If the query is not RUNable then it can't be SARGable. 😀

Thanks Jacob,

Will have a look at the XML approach.

David

Thanks for your reply Greg,

I think I over simplified my request in the hope of making it easier to understand.

What I ultimately need to do is add records to...