Concatenate XML From Various XML Columns without type casting to string

[oblandon]

I have three XML columns in my SQL Table (single row table just used for storing XML) and the XML structure is something like this:In Column 1 - \[code\]<Column1XML> ....</Column1XML>\[/code\]In Column 2 -\[code\]<Column2XML> ....</Column2XML>\[/code\]In Column 3 - \[code\]<Column3XML> ....</Column3XML>\[/code\]The final resultant XML that I am looking for is:\[code\]<SomeTagName> <Column1XML> .... </Column1XML> <Column2XML> .... </Column2XML> <Column3XML> .... </Column3XML></SomeTagName>\[/code\]How can I obtain this required structure without doing string concatenation? I am sure there must be a way out with Typed XML.Thanks in advance for looking up my question.