query out to XML

hi,
i need to write a query and export the result to an xml file. how would I
do that?
thanksHave a look at the 'FOR XML AUTO' extension to the select statement i.e.
select * from yourTable for xml auto
Peter
"Denial ain't just a river in Egypt."
Mark Twain
"Rafael Chemtob" wrote:

> hi,
> i need to write a query and export the result to an xml file. how would I
> do that?
> thanks
>
>