SQL Server 2005 XML: FOR XML PATH -> cdata?

stoves · #1 (**permalink**) February 21st, 2007, 09:05 AM

Hello,

Is it possible to output a column as cdata when using xml path?
For example:

Code:

SELECT CustomerID as "@CustomerID", 
           CompanyName,
           Address as "address/street",
           City as "address/city",
           Region as "address/region",
           PostalCode as "address/zip",
           Country as "address/country",
           ContactName as "contact/name",
           ContactTitle as "contact/title",
           Phone as "contact/phone", 
           Fax as "contact/fax"
FROM Customers
FOR XML PATH('Customer'), ROOT('doc')

Is there a way to output street address as cdata? Right now I'm using FOR XML EXPLICIT to output cdata, but my query is getting quite complicated and I would like to switch to the path method.

Thanks!

JacobSebastian · #2 (**permalink**) July 8th, 2008, 03:40 AM

You should use FOR XML EXPLICIT if you intend to generate CDATA sections.

Jacob Sebastian SQL Server MVP www.sqlserverandxml.com www.sqlkatmai.com

Need to download code?

Navigation