SQL Server/T-SQL Tutorial/String Functions/REPLACE
REPLACE takes three strings as parameters, and all instances of the second string in the first are replaced by the third string.
<source lang="sql">
The syntax is: REPLACE(string to search, string to find, string to replace) 5> 6> SELECT REPLACE("sqle.ru","java","JAVA") 7> GO
sqle.ru
(1 rows affected)</source>