Hello guys, i have xml file that have value and value contain double qoat in that xml is given below please help me select data from that.
DECLARE @XMLstr AS NVARCHAR(MAX)
SELECT @XMLstr =
DECLARE @xml XML
SELECT @xml = CAST(REPLACE(@XMLstr, '''', '''''') AS XML)
SELECT @xml FOR XML PATH('')
actually i wants to store quote in table "2/2018 Just like we store height foot and inch 5'6 like that "2/2018 please help me.
23 People are following this question.