HTTP_DECODE( string )

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.

• HTTP_ENCODE function [Web service]
• Web services functions
• Web services system procedures

The following statement returns the string http://dcx.sybase.com:

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