I have big dynamic XMLs which I manipulate as string. I have “[” or “]” symbol inside my data. When I try to insert that elements in CDATA I got error. In general error is:

Msg 9436, Level 16, State 1, Line 5 XML parsing: line 4, character 48111, end tag does not match start tag

If I remove CDATA elements the XML is ok (I remove manually CDATA and then replace <> and then cast to XML). Is there a way to escape “[” or “]” symbols inside data to avoid that error?