Mega Code Archive

 

Categories / MSSQL / String Functions

 

REPLACE

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.rntsoft.com","a","sql server") 6> GO -------------------------------------------- www.jsql servervsql server2s.com (1 rows affected) 1>