How to add nodes into xml?

I want to add some nodes into xml variable:
For example:
The original xml:
<PO>
<PONO>123</PONO>
<PODATE>07252007</PODATE>
<POCNAME>ABC Company</PONAME>
<POITEMS>
..
..
</POITEMS>
<POFOOTER>No Message</POFOOTER>
</PO>
I want insert several POFEATURES node into xml as:
<PO>
<PONO>123</PONO>
<PODATE>07252007</PODATE>
<POCNAME>ABC Company</PONAME>
<POFEATURES>Special Items Mark</POFEATURES>
<POFEATURES>Special Client Mark</POFEATURES>
<POFEATURES>Credit Account</POFEATURES>
<POITEMS>
..
..
</POITEMS>
<POFOOTER>No Message</POFOOTER>
</PO>
How to use modify() to do that?ABC wrote:

> How to use modify() to do that?
Here is an example, using a variable of type xml but you could as well
use a column of that type:
DECLARE @.x xml;
SET @.x = '<PO>
<PONO>123</PONO>
<PODATE>07252007</PODATE>
<POCNAME>ABC Company</POCNAME>
<POITEMS>
..
..
</POITEMS>
<POFOOTER>No Message</POFOOTER>
</PO>';
SET @.x.modify('
insert (
<POFEATURES>Special Items Mark</POFEATURES>,
<POFEATURES>Special Client Mark</POFEATURES>,
<POFEATURES>Credit Account</POFEATURES>
) after (PO/POCNAME)[1]
');
SELECT @.x;
Martin Honnen -- MVP XML
http://JavaScript.FAQTs.com/