Excluding nodes from XML data before returning from SQL Server

This post follows on from a question I recently replied to, for how to exclude a specific node from an XML column value before returning it, using TSQL. Example setup CREATETABLEExample(IDINTEGERIDENTITY(1,1)PRIMARYKEY,XmlFieldXML)INSERTExample(XmlField)VALUES('<Root><ChildA>Value I want to see</ChildA><ChildB>Value I do not want to see</ChildB></Root>')So if you want to return the XML minus the ChildB node, how do you do it? Modify it Literally, using the modify method that is supported on the XML data type. [Read More]