AND

All functions > LOGICAL > AND

Returns TRUE if both arguments are true.

Signatures

Returns: TRUE if both expressions are TRUE, FALSE otherwise

AND(expr1: BOOLEAN, expr2: BOOLEAN) → BOOLEAN

Notes

• Logical AND operator for boolean expressions
• Returns TRUE only when both operands are TRUE
• Returns FALSE if either operand is FALSE
• NULL handling: Returns NULL if either operand is NULL and the other is TRUE
• Short-circuit evaluation may apply (expr2 not evaluated if expr1 is FALSE)
• Can be chained: expr1 AND expr2 AND expr3
• Commonly used in WHERE clauses and conditional logic

See also

• Operators