Yup...You are correct...Thanks..

Here is What I have (DATA), 2 customers with ID, FirstName and LastName

customer xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<customer>

<ID>74374E76-DD16-473B-BC35-735E68234B5A</ID>

<firstName>EVCARRIE</firstName>

<lastName>CONSUMER</lastName>

</customer>

...

I have the below xml in my table, the user can add/edit the existing customer...so if I pass the whole customer data...I should see in the existing below xml...if found...

Never Mind Jocob...Thanks..I got it

One more thing Jocob, my main purpose of this is.. I want add an element(ID) under each node Customer Node

Jocb, This is not working with SET statement, Its always inserting an element under first node.

could you please convert my example and send it back...Thanks for your help

DECLARE @index int

SET @index = 0

DECLARE @charCount as varchar(1)

DECLARE @count int

SET @charcount = CAST(@CustomerData.query('count(/customer/customer)') as varchar)

SET @Count = CAST(@charCount as int)

WHILE @index < @count

BEGIN

DECLARE...

position()=sql:variable("@i") is not working for me, I am working on SQL 2005, basically I was trying to loop each node and insert an element..so if I use [1] or [2]...