HTTP_DECODE function [HTTP]

Decodes special characters within strings for use with HTTP.

Syntax
HTTP_DECODE( string )
Parameters
  • string   Arbitrary string to be used in an HTTP request.

Returns

LONG VARCHAR

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.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.