REPLACE takes three strings and replaces all the occurrences of the second string with the third string in the first string.
REPLACE
REPLACE('I have 3 problems', 3, 0)
This will return 'I have 0 problems'.
'I have 0 problems'
Last updated 2 years ago
Was this helpful?