Hi all, I would like to change a sub-string in a text-field by using
UPDATE tablename SET fieldname=regexp_replace(fieldname,old_sub_string,new_sub_string) WHERE (fieldname like '%old_sub_string%') In priniciple, it works. However, only one occurence of old_sub_string is replaced and further not. Which syntax has to be used to replace all old_sub_strings by new_sub_string in a text-field at once? I have seen something like '\&' in the docs and tried it, but I failed. Any Idea? Thanks a lot! Ciao, Tino ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
