Backup table to xml or csv file, content is long text

[BlueAngel]

I have a table that contains content (like blog posts, so fairly long text) that I want to export to a xml file.So I want it like:\[code\]<table> <column1>1231</column1> <column2>January 1, 2001</column2> <column3>some very long text will all types of characters in it</column3></table>\[/code\]Is there a built in way to do this?Basically each column will have its own element.The content should ideally be CDATA since the content can contain any type of character potentially.I have sql server 2008 express.