RegexEscape
Returns a regular expression escaped string
- Free Function
- SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017
SELECT SQLHTTP.net.RegexEscape ( @Text )
| Name | Type | Description |
|---|---|---|
| @Text | nvarchar(MAX) | String to escape |
nvarchar(MAX)
|
1 2 3 4 5 6 7 |
DECLARE @Text nvarchar(MAX) SET @Text = 'A thousand dollars = $1,000.00' SELECT SQLHTTP.net.RegexEscape(@Text) |
|
1 2 3 4 5 |
------------------------------------- A\ thousand\ dollars\ =\ \$1,000\.00 |