APOSTROPHE inside xml element value

Question

How Should I write an elements value inside an XML which contains apostrophe? Is there an escape sequence for the same?

I am dynamically getting an xml, something like this from a sql Select. Now in this case emp_name O''DELL, SEAN in itself contains apostrophe. How should I be getting emp_name so a proper xml could be formed?

<Result type="Benefit" emp_id='332' emp_name='O''DELL, SEAN '/>

Thanks Guys.

Answer 1

Use ' in place of '. Check this.