Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

REPLACE takes three strings as parameters, and all instances of the second string in the first are replaced by the third

The syntax is: REPLACE(string to search, string to find, string to replace) 5> 6> SELECT REPLACE("rntsoft.com","java","JAVA") 7> GO ------------------------------------------------------------------------------------------------------------------------ -------------------------------------------------------------------------------- rntsoft.com (1 rows affected)