SQL Server/T-SQL Tutorial/String Functions/REPLACE

Материал из SQL эксперт
Перейти к: навигация, поиск

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


(1 rows affected)</source>