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.

Returns a Yes/No value, depending on the check

  • If Condition1 and Condition2 both evaluate to false, then No is returned.

  • if Condition1 or Condition2 evaluates to true, then Yes is returned.

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