Logical-or |, or

Operator: | , or

The logical operator | (or) checks if at least one of two conditions evaluates to true. The operators | and or can both be used and are exactly the same.

If used together with the logical and operator, the precedence is important: and takes precedence over or. We strongly advice to use (parentheses) to correctly group these logical statements.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

condition1 | condition2

(6=6) | ("Hello world" = "Hello world") => Yes

false | false => No

false | true => Yes

true | "text" => expression type mismatch

condition1 or condition2

(6=6) or ("Hello world" = "Hello you") => Yes

false and true or false => No

false and true or true => Yes

(false and true) or true => Yes

false and (true or true) => No

Last updated

Was this helpful?