Hi Experts,

Can anybody tell me the code for converting the table
records to a XML document.

I want to write a procedure which will return a string
( varchar(8000) )
containing the xml document.

The Sample XML document i need in the form of string is:

<QATollFreeLocations>
    <LocationName>USA</LocationName>
    <LocationNumber>123456453478</LocationNumber>
</QATollFreeLocations>


Please guide me with an example

Regards,

KG

__________________
KG

Hi

Guess a bit late while responding, but the most simple option you can use is within your select statement, i.e.

select * from table for XMLAUTO

(In place of * use your field names, and in place of table use your table name)

If you need more generalized XML conversion, do let me know.

Regards
Mike