Replace

SELECT oreplace('Hello There','Hello','Hi')

This converts Hello There to Hi There.