I have a table with one field containing XML value of the given structure. (level1) (level2) (name)Name1(/name) (Value)123(/Value) (/level2) (level2) (name)Name2(/name) (Value)345(/Value) (/level2) (level2) (name)Name3(/name) (Value)122(/Value) (/level2) (/level1) I want to update the xml field to remove an element from the xml field of each of the rows of the table. I want to remove the element (level2) which have a child element with name 'Name3'. Only some of the fields contain this element and only one element with name 'Name3' will be contained in an xml field. I have used () for denoting an xml element since this webpage is not displaying the xml node using angle brackets.