update XML value

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.