I want to control XML Type.

Is it posible to modify xml data of XML Type by T-SQL ?

I haven't been used to CLR in procedure.but i think that it is posible to modify.

Could you tell me how to use XML data by T-SQL

Thanks for you.

It will help if you describe the modifications you want to make; include an example of the kind of XML data you would like to modify and the expected result.