Name

REPLACE()

Synopsis

REPLACE(str, from, to)

Returns the string str with all occurrences of the string from replaced with the string to. The search and replace is case-sensitive when searching for from. This code returns the string “Cheeseburger and Soda”:

SELECT REPLACE('Cheeseburger and Fries', 'Fries', 'Soda');