SQL SERVER Replace Query

SQL SERVER Replace Query/

Using REPLACE in an UPDATE statement

SELECT Replace('SQLTeam.com Rocks!', 'Rocks', 'Rolls')