Escape double quotes in sybase

Question

I run a query in a database to retrieve records in CSV format (with quotes):

"Data","More data","some "funny" data with quotes","more".

Now that this has been analyzed, an obvious problem arises with this bit:

...,"some "funny" data with quotes",...

Is there a way to “avoid” these quotes in sybase to save post processing?

Answer 1

if it's just a double quote that you want to select in a literal string, use a single quote as a line separator.

Try selecting '' 'and you will see

Answer 2

- after completing this sentence: SET QUOTED_IDENTIFIER ON

- you will be able to execute: select count (*) from "/ table / name" go