Use of the Replace function in SQL Server _mssql

REPLACE

Replaces all occurrences of the second given string expression in the first string expression with the 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 find. String_replace2 can be either character data or binary data.

"' String_replace3 '"

The string expression to replace. 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, the character data is returned. Returns binary data if String_replace (1, 2, or 3) is one of the supported binary data types.

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)