Nicky,

OK ... check out the FOR XML clause of a SELECT in the BOL help. This only applies to SQL 2000 I think ... I don't think it was available for SQL 7.

~~Bonnie

>Hey Bonnie!
>
>What I meant to ask was if there is a way to take data from a SQL table and export it to an XML document?
>
>Thanks for your assistance!
>
>Nicky