convert nvarchar() to xml

• bkshn

  Right there with Babe

  Points: 794

  More actions

  November 22, 2013 at 10:51 pm

  #282838

  Hello

  I use SET @text= CAST (@text AS xml) to convert @text to xml, but it didn't work and I have " % " instead of " < "

  Could you help me?

• Rahul Bhosale

  SSC Eights!

  Points: 931

  More actions

  November 23, 2013 at 6:24 pm

  #1668634

  This is only possible if you set the NVARCHAR value as XML like below.

  declare @a nvarchar(max)

  set @a = N'<root><name> SQL Server 2012</name></root>'

  select cast(@a as xml)

  It will not be meaningful to have XML as '%' as this is not syntactivally correct for having an XML value.

  Rahul

  Website: http://borngeek.in