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

Syntax

BOOL_OR(<expression>)

Parameters

ParameterDescriptionSupported input types
<expression>The boolean expression used to calculate the resultBOOLEAN

Return Types

BOOLEAN

Example

nametotalprizedollars
The Drift Championship22,048
The Lost Track Showdown5,336
The Acceleration Championship19,274
The French Grand Prix237
The Circuit Championship9,739

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

SELECT
	BOOL_OR(totalprizeddollars > 20000) as has_big_prize
FROM
	tournaments;

Returns

true