|
1> -- REPLACE: all instances of the second string in the first are replaced by the third string.
2>
3> -- REPLACE(string to search, string to find, string to replace)
4>
5> SELECT REPLACE("www.java2java.com","a","sql server")
6> GO
--------------------------------------------
www.jsql servervsql server2s.com
(1 rows affected)
1>
|