Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I replace all double quotes with single quotes in char and varchar fields?

April 26, 2017char double Fields quotes replace varchar

0

Posted

How do I replace all double quotes with single quotes in char and varchar fields?

1 Answer

0

Posted

Use the REPLACE function – REPLACE(str, find, replacewith)… update HH.MY_TABLE set TEXT_X = replace(TEXT_X, ‘”‘, ”) where TEXT_X like ‘%”%’; Note that the single quote in the replace function is doubled up because you need to escape it.