SQL Update for XML value in table

I have a table with about 200 records and I need to be able to update the values, but it is showing as a XML.

I need to update the AE value with the EN value?  Somehow need to parse this so it can be updated.  Is this possible??

Who is Participating?
käµfm³d 👽Connect With a Mentor Commented:
Try this:

UPDATE [tableName]
set XMLValue.modify('replace value of (/langs/lang[@code="AE"]/text())[1] with (/langs/lang[@code="EN"]/text())[1]')

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.