Hi Scott,

Thanks for the explanation.....

I have been working through the MERGE command on a few websites trying to work out how it works....latest one being this one.

http://www.made2mentor.com/2013/05/writing-t-sql-merge-statements-the-right-way/

Thanks again.....