Read Xml Nodes value containing special characterHello
I am consuming an API response in XML format and want to save XML nodes value within table columns. But SQL is not reading nodes containing special character like '&'. Getting XML parsing error.
is there any way to save nodes value containing the special character in SQL.