TSQL 2005 XML Explicit - CDATA is padded with leading and trailing space?

• andy.welch

  SSC Enthusiast

  Points: 110

  More actions

  February 10, 2012 at 12:52 am

  #251348

  Hi, if I use 'Element' I get <item>bob</item>

  But, if I use CDATA as I need to, I get <item><![CDATA[ bob ]]></item>

  This is in TSQL 2005 via asp.net using C# .NET 3.5

  at this stage I'll have to run regex over it before I output it.

  thx

  Andy

• andy.welch

  SSC Enthusiast

  Points: 110

  More actions

  February 10, 2012 at 12:58 am

  #1445385

  Slightly embarrassing...it's simply the way chrome is displaying the xml data - default stylesheet.