String Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. String Functions
  4. 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)