REPLACE

Description

REPLACE takes three strings and replaces all the occurrences of the second string with the third string in the first string.

Example

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

This will return 'I have 0 problems'.

Last updated