HTTP_DECODE function [Web service]

Decodes HTTP encoded strings. This is also known as URL decoding.

Syntax

HTTP_DECODE( string )

Parameters

string – Arbitrary string taken from a URL or URL encoded request body.

Returns

LONG VARCHAR or LONG NVARCHAR

Remarks

This function returns the string argument after replacing all character sequences of the form %nn, where nn is a hexadecimal value, with the character with code nn. In addition, all plus signs (+) are replaced with spaces.

Standards and compatibility

SQL/2008 – Vendor extension.

Examples

SELECT HTTP_DECODE('http%3A%2F%2Fdcx.sybase.com')