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.

Carl