ReplaceMax
Replaces all occurrences of a specified string value with another string value, regardless of occurrence string size.
- Free Function
- SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017
SELECT SQLHTTP.net.ReplaceMax ( @Text, @Find, @Replacement )
| Name | Type | Description |
|---|---|---|
| @Text | nvarchar(MAX) | The string expression to be searched. |
| @Find | nvarchar(MAX) | The string expression to be found. |
| @Replace | nvarchar(MAX) | The replacement string. |
nvarchar(MAX)
This function is similar to SQL Server’s REPLACE function, but all parameters can be of type nvarchar(MAX).