RegexUnescape

Returns a regular expression un-escaped string

Syntax:

SELECT SQLHTTP.net.RegexUnescape ( @Text )

Arguments:

Name	Type	Description
@Text	nvarchar(MAX)	String to un-escape.

Return Type:

nvarchar(MAX)

Sample Usage:


DECLARE @Text nvarchar(MAX)

SET @Text = 'A\ thousand\ dollars\ =\ \$1,000\.00'

SELECT SQLHTTP.net.RegexUnescape(@Text)

DECLARE @Text nvarchar(MAX)

SET @Text = 'A\ thousand\ dollars\ =\ \$1,000\.00'

SELECT SQLHTTP.net.RegexUnescape(@Text)

-------------------------------------

A thousand dollars = $1,000.00