> ## 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/aggregation/bool_or",
  "feedback": "Description of the issue"
}
```

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

</AgentInstructions>

> Reference material for BOOL_OR

# BOOL_OR

Returns true if any non NULL input value is true, otherwise false. If all input values are NULL values, returns NULL.

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
BOOL_OR(<expression>) [FILTER ([WHERE] <condition>)]
```

## Parameters

| Parameter      | Description                                                       | Supported input types |
| :------------- | :---------------------------------------------------------------- | :-------------------- |
| `<expression>` | The boolean expression used to calculate the result               | `BOOLEAN`             |
| `<condition>`  | An optional boolean expression to filter rows used in aggregation | `BOOL`                |

## Return Types

`BOOLEAN`

## Example

| name                          | totalprizedollars |
| :---------------------------- | :---------------- |
| The Drift Championship        | 22,048            |
| The Lost Track Showdown       | 5,336             |
| The Acceleration Championship | 19,274            |
| The French Grand Prix         | 237               |
| The Circuit Championship      | 9,739             |

We want to see if any of the tournaments have prize value more than 20,000

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	BOOL_OR(totalprizeddollars > 20000) as has_big_prize
FROM
	tournaments;
```

**Returns**

`true`