> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference material for URL_DECODE function

# URL_DECODE

Decodes [percent-encoded](https://en.wikipedia.org/wiki/Percent-encoding) characters and replaces them with their binary value.

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
URL_DECODE(<expression>)
```

## Parameters

| Parameter      | Description               | Supported input types |
| :------------- | :------------------------ | :-------------------- |
| `<expression>` | The string to be decoded. | `TEXT`                |

## Return Type

`TEXT`

## Example

The example below decodes the percent-encoded parameters of an URL:

<div className="query-window">
  ```
  SELECT URL_DECODE('https://www.firebolt.io/?example_id%3D1%26hl%3Den');
  ```

  | url\_decode <span>text</span>                                                                 |
  | :-------------------------------------------------------------------------------------------- |
  | [https://www.firebolt.io/?example\_id=1\&hl=en](https://www.firebolt.io/?example_id=1\&hl=en) |

  <p><span>Rows: 1</span><span>Execution time: 6.38ms</span></p>
</div>

## Related

* [URL\_ENCODE](/reference-sql/functions-reference/string/url_encode)