PercentDecode

Decodes a string that was previously percent-encoded.

Syntax:

SELECT SQLHTTP.net.PercentDecode ( @String )

Arguments:

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

Return Type:

nvarchar(max)

Remarks:

See the following Wikipedia articles for more information about Percent-encoding

Sample Usage:


SELECT SQLHTTP.net.PercentDecode('I%20can%20now%20percent-encode%20%26%20percent-decode%20using%20SQL%20Server')

SELECT SQLHTTP.net.PercentDecode('I%20can%20now%20percent-encode%20%26%20percent-decode%20using%20SQL%20Server')

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

I can now percent-encode & percent-decode using SQL Server