使用TSQL从XML中删除具有特定值的节点

I'm trying to parse a piece of XML and remove nodes that contain certain values. I know how to remove them if the value is exact, but I want to use something like a "contains".I'm trying to parse a piece of XML and remove n