Quicker way to replace apostrophes from a db 1

[Jamfool]

At the moment a cursor is used to go thru all the fields in the database with a column datatype varchar/char, and then replace the apostrophes.


Does anyone know a quicker way to replace apostrophes?

 

[swampBoogie]

update t set c1 = replace(c1,'''',''),c2 = replace(c2,'''','')
 where c1 like '%''%'

(replace is not an ANSI SQL function but many dbms suport it.

Why should you replace apostrophes?

 

[Pekka]

Or you don't even have to use cpysplf. You can copy/paste it via CA Operation navigator.

 

[Jamfool]

Why should you replace apostrophes?

A: We need to remove them because they cause problems when used in a data transfer program, which see them as delimiters

 

[sem]

I suppose you should change that program

Regards, Dima