sql - APOSTROPHE inside xml element value -


How do I write an element value inside an AML, which contains an apostrophe? Is this an escape sequence for this?

I'm dynamically fetching an XML, choose something like this from a SQL Now in this case emp_name O'Neill, myself include SEAN apostrophe How can I get emp_name so that a proper Can XML be formed?

  & lt; Result type = "profit" emp_id = '332' emp_name = 'O'Dell, SEAN' />   

Thanks guys.

Use & amp; Apos; Check 'instead of '.

Comments