Link Search Menu Expand Document

BOOL_OR

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

Parameter Description Supported input types
<expression> The boolean expression used to calculate the result BOOLEAN

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

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

Returns: true