replace single apostrophe with 2 apostrophes in a single sql statement [message #9005] |
Fri, 10 October 2003 11:02 |
Hugh
Messages: 7 Registered: April 2002
|
Junior Member |
|
|
Hi,
I want to replace all single apostrophes with 2 of the for a column in a table.
I know the syntax is something like
update peiscompany SET co_name = translate(co_name,'s','d');
where s is a single apostrophe and d would be 2 single apostrophes however I can't get it right.
I've tried the following but with no luck
update peiscompany SET co_name = translate(co_name,chr(39),chr(39)||chr(39));
Can someone help me?
Cheers
|
|
|
|