Use of SQL Server replace functions

Replace
Replace all the second given string expressions in the first string expression with the third expression.

Syntax
Replace (''string _ replace1 '', ''string _ replace2'', ''string _ replace3 '')

Parameters
''String _ replace1''

String expression to be searched. String_replace1 can be character data or binary data.

''String _ replace2''

String expression to be searched. String_replace2 can be character data or binary data.

''String _ replace3''

String expression used for replacement. String_replace3 can be character data or binary data.

Return type
If string_replace (1, 2, or 3) is one of the supported character data types, character data is returned. If string_replace (1, 2, or 3) is one of the supported binary data types, binary data is returned.

Example
In the following example, replace the string CDE in abcdefghi with xxx.

Select Replace (''abcdefghicde'', ''cde'', ''xxx') Go
The following is the result set:

------------ Abxxxfghixxx (1 row (s) affected) -- Reference