Microsoft SQL Server String Functions Replace
Example
Returns a string (varchar or nvarchar) where all occurrences of a specified sub string is replaced with another sub string.
Parameters:
- string expression. This is the string that would be searched. It can be a character or binary data type.
- pattern. This is the sub string that would be replaced. It can be a character or binary data type. The pattern argument cannot be an empty string.
- replacement. This is the sub string that would replace the pattern sub string. It can be a character or binary data.
SELECT REPLACE('This is my string', 'is', 'XX') -- Returns 'ThXX XX my string'.
Notes:
- If string expression is not of type
varchar(max)ornvarchar(max), thereplacefunction truncates the return value at 8,000 chars. - Return data type depends on input data types - returns
nvarcharif one of the input values isnvarchar, orvarcharotherwise. - Return
NULLif any of the input parameters isNULL
