Roman,

Sorry, your previous post should have the solution stars I picked the wrong posting.

Thank you SOOOOO much, worked exactly as advertised.

Rhonda

UPDATE MyTable1
SET ContactName = MyTable2.ContactName
FROM MyTable1,
(SELECT * 
FROM OPENXML (@idoc, '/ROOT/Customer',1)
WITH (CustomerID varchar(10),
ContactName varchar(20))) AS MyTable2
WHERE MyTable1.CustomerID = MyTable2.CustomerID

>Ignore the PRE and /PRE tags in the previous message, the instructions I got for formatting the code were not clear enough, I was probably supposed to use something else.
>
>Roman