REPLACE
Replaces all occurrences of the second given string expression in the first string expression with a third expression.
Grammar
REPLACE (' String_replace1 ', ' string_replace2 ', ' string_replace3 ')
Parameters
"' String_replace1 '
The string expression to search for. String_replace1 can be either character data or binary data.
"' String_replace2 '
The string expression to be found. String_replace2 can be either character data or binary data.
"' String_replace3 '
The replacement string expression. String_replace3 can be either 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, the binary data is returned.
Example
The following example replaces the string CDE in Abcdefghi with XXX.
SELECT REPLACE (' abcdefghicde ', ' cde ', ' xxx ') GO
Here is the result set:
------------abxxxfghixxx (1 row (s) affected)
Use of the SQL Server replace function