I am having trouble putting quotes around the following string value select statement in sql. How do I do it?
Convert(Xml, OM.Body).value('"(//DocumentResponseMessage/ecf:Document/ecf:DocumentMetadata/d:RegisterActionDescriptionText)','varchar(250)"') AS 'CaseEventDescription',
The reason I need to do that is because the value has a comma in it and when I put the output in Excel, it is not fitting in one column. So putting quotes will help but I don't know exactly how to do it.