REPLACE

[shultz]

How can I use the REPLACE command on the SQL server to replace all the apostrophes with double apostrophes. For example I take a field called description which has a lots of "'"s.

UPDATE tblImport
SET [CSR DESCRIPTION] = REPLACE([CSR DESCRIPTION], "'", "''&quot

is the above syntax correct? It is not accepting the double quotes. Can anybody give me the equivalent one.

thanks.

 

[fluteplr]

Try this.

UPDATE tblImport
SET [CSR DESCRIPTION] =
REPLACE([CSR DESCRIPTION], char(39),char(39)+char(39))

 

[shultz]

Sorry, I forgot to tell you that the datatype is "NTEXT". Is it possible to do the above with these kinds of data.

thanks.

 

[fluteplr]

Don't know but I can't see why not. Why don't you copy a few records to a temporary table and try it?