You can use the ELEMENT directive to create a child-node.

-Mike

>>I don't think that you'll be able to get this with XML AUTO but you can if you use XML EXPLICIT. XML EXPLICIT is very flexible. You can create any document structure that you need - but it is more work on your part.
>>
>>-Mike
>>
>>>Hi All,
>>>
>>>I am wondering if there is a way for SQL to add attributes into the elements of the results that I return. I.E
>>>
>>>SELECT transname,
>>> transfer
>>>from transferee TranNode
>>>XML AUTO, ELEMENTS
>>>
>>>I want my XML to look like this
>>>

>>><TranNode>
>>>  <transname>MyName</transname>
>>>  <transfer transprocess="true">MyTransfer</transfer>
>>><TranNode>
>>>

>>>I would like someway to add the "transprocess" attribute in SQL and not in the DOM doc. Any help will be very very much appreciated.
>
>Hi Mike,
>
>One problem I have not been able to over come is that XML explicit also places all of the elements in as Attributes to the root node. Is there a way to get around this.
>
>Carl
>
>>>
>>>Carl