Provide quotes for copying in csv from sql

Question

I have the data like below :

 174 ROAD "O" NW

But i want the data like "174 ROAD ""O"" NW"

It means if i have quotes present the new quote should be added in sql query

Answer 1

I guess you can use replace:

select '"' + replace (col, '"', '""') + '"'
from your_table;