Replace Function

The replace() function returns a string formed by substituting string describe in the third parameter for every occurrence of string describe in the 2nd parameter from the string describe in 1st parameter.

The syntax is Replace(String , Find String , Replace With) , it is case sensitive.

        SELECT Replace('SQLDatabase.Net', 'LD', 'L-D') /* returns SQL-Database.Net */ ;

SELECT Replace('SQLDatabase.Net', 'a', 'T') /* returns SQLDTtTbTse.Net */ ;

Replace statement does not alter data in the database, to alter data use Update statement with replace.