What does `REPLACE(str, ‘old’, ‘new’)` do in SQL?

Question

Advanced SQL Developer — Easy

What does `REPLACE(str, ‘old’, ‘new’)` do in SQL?

Accepted Answer

The `REPLACE(str, 'old', 'new')` function in SQL replaces all occurrences of 'old' with 'new' in the string. This means that every instance of 'old' will be substituted with 'new' throughout the entire string.