Handle apostrophesn inbound xml

Larry Brister
Larry Brister used Ask the Experts™
on
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

However...
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Consultant
Top Expert 2009
Commented:
i dont thing it will throw an error when you pass the xml from the application. if you are passing the sting with single quotes from tsql, then you chould replace single quotes with two singlw quotes
Larry Bristersr. Developer

Author

Commented:
aneeshattingal
Should I do that on the vb side?  Or with some kind of an xml.mofify in SQL
Larry Bristersr. Developer

Author

Commented:
VB side.
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial