REPLACE with no match

Question

Accepted Answer

When the search string is not found anywhere in the input, REPLACE returns the original string unchanged. 'xyz' does not appear in 'hello world', so the output is 'hello world'. REPLACE never returns NULL just because there was no match - it only returns NULL if the input string itself is NULL.