> ## 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.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/functions-reference/string/url_decode",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> 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":"github-light","dark":"github-dark"}}
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:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT URL_DECODE('https://www.firebolt.io/?example_id%3D1%26hl%3Den');
```

**Returns**: `https://www.firebolt.io/?example_id=1&hl=en`

## Related

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