I am running a query on a database to retrieve records in a CSV (with quotes) format:
"Data","More data","some "funny" data with quotes","more"
.
Now when this is parsed, there is an obvious problem with this bit:
...,"some "funny" data with quotes",...
Is there a way to "escape" these quotes in sybase to save me post-processing?