Update signed type xml column

Question

What is the syntax to update the value 121212 to another field's value within the same table? The column has this when clicked on: 

<DocumentElement>
  <TestData>
    <TestID>5</TestID>
    <TestCategoryID>800</TestCategoryID>
    <Value1>121212</Value1>
  </TestData>
</DocumentElement>

I think it has to be something similiar to:

UPDATE t
SET field1.modify(
('/DocumentElement/TestData[TestCategoryID[1]="800"]').value('TestData[1]/Value1[1]', 'varchar(100)')
replace value of

---

Barret

Answer 1

Includes links to topics that explain events in VBScript.

---

Mark Van Deibert