Decodes HTTP encoded strings. This is also known as URL decoding.
HTTP_DECODE( string )
string Arbitrary string taken from a URL or URL encoded request body.
LONG VARCHAR or LONG NVARCHAR
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.
SQL/2008 Vendor extension.
SELECT HTTP_DECODE('http%3A%2F%2Fdcx.sybase.com')