All occurences in built-in replace function

[Astashonok]

Can built-in replace function act like REPLACE ALL OCCURENCES statement?

I found out it only replace only the occurence specified in occ parameter.

[DoanManhQuynh]

You can set occ = 0 to replace all.

[Sandra_Rossi]

Pavel Astashonok maybe you were mislead by the text in the "occ" part, the documentation is to be read very carefully...:

• replace: "If occ contains the value 0, all occurrences are replaced"
• occ: "Except in the case of the replacement function replace, the value 0 raises an exception"

[Astashonok]

Yes, my bad. I noticed only part of documentation with exception