XML : XML Search and Change in Sql Server XML Datatype column

Hi I would like to update "xml" datatype column of a table of all the records in that table.

For example below is the content of Xml for a record.

   <assessmentItem xmlns="http://www.imsglobal.org/xsd/apip/apipv1p0/qtiitem/imsqti_v2p2"  adaptive="false" identifier="VHXYZ" timeDependent="false" title="ZonesSS" toolName="IBIS Export" toolVersion="1.0" >      <responseDeclaration baseType="identifier" cardinality="single" identifier="VH221999_order_match_choice_list_10.RESPONSE">          <correctResponse>              <value>i2</value>          </correctResponse>      </responseDeclaration>      <outcomeDeclaration baseType="float" cardinality="single" identifier="SCORE">          <defaultValue>              <value>0</value>          </defaultValue>      </outcomeDeclaration>  </assessmentItem>    

want to change this to

  <assessmentItem xmlns="http://www.imsglobal.org/xsd/apip/apipv1p0/qtiitem/imsqti_v2p2"  adaptive="false" identifier="VHXYZ" timeDependent="false" title="ZonesSS" toolName="IBIS Export" toolVersion="1.0">      <responseDeclaration baseType="identifier" cardinality="single" identifier="RESPONSE">          <correctResponse>              <value>i2</value>          </correctResponse>      </responseDeclaration>      <outcomeDeclaration baseType="float" cardinality="single" identifier="SCORE">          <defaultValue>              <value>0</value>          </defaultValue>      </outcomeDeclaration>     </assessmentItem>    

Basic change is change the value of attribute identifier="RESPONSE" in <responseDeclation> Tag.