Returns true if either argument evaluates to true. Equivalent to the || operator.

Since the function returns a Boolean value, it can be used as a function or a conditional.

NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Logical Operators.

 

or(daysBillOverdue > 90, violationsCount > 2)

Output: If the value in the daysBillOverdue column is greater than 90 and the value in violationsCount column is greater than 2, then the returned value is true. Otherwise, the value is false

or(value1, value2)


ArgumentRequired?Data TypeDescription
value1YstringThe first value must be a Boolean literal, column reference, or expression that evaluates to true or false.
value2YstringThe first value must be a Boolean literal, column reference, or expression that evaluates to true or false.

value1, value2

Expressions, column references or literals to compare as Boolean values.

Required?Data TypeExample Value
YesFunction or column reference returning a Boolean value or Boolean literalmyHeight > 2.00


Example - Logical Functions