REPLACE

Description

REPLACE takes a string, a value to find, and a replacement value, and returns a new string with all occurrences of the found value replaced.

Example

REPLACE('I have 3 problems', 3, 0)

This returns "I have 0 problems".

Example with strings

REPLACE('Hello World', 'World', 'Atfinity')

This returns "Hello Atfinity".