update an xml node

Question

Hi,

 

In a sql server table xml is stored as  nvarchar and now I want to update some xml node values based on specific condition. Please let me know how can we do that