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

















sqle.ru

















(1 rows affected)</source>

Источник — «http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/String_Functions/REPLACE&oldid=6231»