UrlDecode

Decodes a URL-Encoded string.

Syntax:

SELECT SQLHTTP.net.UrlDecode ( @String )

Arguments:

Name	Type	Description
@String	nvarchar(MAX)	Any character string, variable, or expression.

Return Type:

nvarchar(max)

Remarks:

See the following Wikipedia article on Percent Encoding

Sample Usage:


SELECT SQLHTTP.net.UrlDecode('I+can+now+encode+%26+decode+a+URL+string+using+SQL+Server')

SELECT SQLHTTP.net.UrlDecode('I+can+now+encode+%26+decode+a+URL+string+using+SQL+Server')

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

I can now encode & decode a URL string using SQL Server