OR

Combines this expression with another using a logical OR operator.

This infix function creates a compound condition that is true if either the current expression or the provided expression (or both) are true. This is essential for building flexible WHERE or HAVING clauses that match records based on alternative criteria.

Example

// Find all employees who are either younger than 21 or older than 60
// Generates: ("age" < 21) OR ("age" > 60)
(Employees.age LT 21) OR (Employees.age GT 60)

Parentheses are often used to group expressions and ensure correct order of evaluation, especially when mixing AND and OR.

Parameters

See also