I have to replace ' by an empty string in a table:

update dta set musiker =  replace('  with '' in musiker);

does not work.

Thanks Uli

Uli,

> update dta set musiker =  replace('  with '' in musiker);

update dta set musiker =  replace(''''  with '' in musiker);


--
Fernando Dias
[Team Elevate]

PS:
I assumed you want to replace a single quote with an empty string.
If that's not the case and what you want is to replace a single quote
with 2 single quotes then :

update dta set musiker =  replace(''''  with '''''' in musiker);

--
Fernando Dias
[Team Elevate]

Fernando,

<<
update dta set musiker =  replace(''''  with '' in musiker);
>>

Thanks. That's it.

Uli