> ## 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/conditional-and-miscellaneous/coalesce",
  "feedback": "Description of the issue"
}
```

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

</AgentInstructions>

> Reference material for COALESCE function

# COALESCE

Checks from left to right for the first non-NULL argument found for each entry parameter pair.

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
COALESCE(<expression> [,...])
```

## Parameters

| Parameter      | Description                    | Supported input types |
| :------------- | :----------------------------- | :-------------------- |
| `<expression>` | The expression(s) to coalesce. | Any                   |

## Return Types

Same as input type

## Example

The following example returns the first non-NULL value provided, which is the username `esimpson`:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT COALESCE(NULL, 'esimpson','sabrina21') AS nicknames;
```

**Returns:** `esimpson`