CODE EXAMPLE FOR SQL

modify xml in sql server

UPDATE user_details
SET xml_data = REPLACE(CAST(xml_data AS NVARCHAR(MAX)), '<fname>Jo</fname>', '<fname>Josef</fname>')
WHERE user_id = 1