Unanswered: escape characters in query result strings?
I'm a SQL novice and this is perhaps an easy question but my search abilities have failed me. I have a table with text data in it that contains single quotes, slashes, and carriage returns plus line feeds. I'm trying to find a way to run a select statement such that the aforementioned characters are already escaped in the output. Example:
select * from tableblah
1 this can\'t be that hard!\r\nHow do you do it?
Any ideas? I am completely limited to a select statement's return results - no output files, etc, as this query is being ran through a browser interface which returns the results (vBulletin interface).