URL_DECODE
The URL_DECODE scalar function completes URL decoding of the provided text using UTF-8 encoding.
- character-string
- An expression that returns a built-in character string that is currently encoded.
The result of the function is a varying length character string that contains character-string after being decoded.
Example
- Decode the string https://www.example.com/search?q=IBM®+i+Q%26A
ReturnsVALUES URL_DECODE('https://www.example.com/search?q=IBM+i+Q%26A')
https://www.example.com/search?q=IBM i Q&A