add element/node to XML column

[Bittu]

In the following xml column data\[code\]<GPCodedValueDomain2 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:typens="http://www.esri.com/schemas/ArcGIS/10.0" xsi:type="typens:GPCodedValueDomain2"> <DomainName>tlu_Loss_List</DomainName> <FieldType>esriFieldTypeString</FieldType> <MergePolicy>esriMPTDefaultValue</MergePolicy> <SplitPolicy>esriSPTDefaultValue</SplitPolicy> <Description>Loss_Reason</Description> <Owner>DBO</Owner> <CodedValues xsi:type="typens:ArrayOfCodedValue"> <CodedValue xsi:type="typens:CodedValue"> <Name>Abandoned</Name> <Code xsi:type="xs:string">AB</Code> </CodedValue> <CodedValue xsi:type="typens:CodedValue"> <Name>Coyote</Name> <Code xsi:type="xs:string">CO</Code> </CodedValue> </CodedValues> </GPCodedValueDomain2> \[/code\]How would one go about inserting via an insert statement, an addition node, such as adding the following:\[code\] <CodedValue xsi:type="typens:CodedValue"> <Name>Dog</Name> <Code xsi:type="xs:string">DG</Code> </CodedValue> \[/code\]