PercentEncode

Percent-Encodes a string.

Syntax:

SELECT SQLHTTP.net.PercentEncode ( @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.PercentEncode('I can now percent-encode & percent-decode using SQL Server')

SELECT SQLHTTP.net.PercentEncode('I can now percent-encode & percent-decode using SQL Server')

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

I%20can%20now%20percent-encode%20%26%20percent-decode%20using%20SQL%20Server