I have a stored procedure that accepts and processes an XML paramater being passed in.
The xml is then processed with
EXEC sp_xml_preparedocument @handle OUTPUT, @XmlDoc_Local
The XML occassionally comes in with apostrophes (Bing's) and my procedure errors out.
Is there a way to modify the inbound XML to strip or handle the apostrophes?