AND
Syntax
<and-expression> := 'AND(' <Boolean> ',' <Boolean> ')'
<and-expression> := <Boolean> 'AND <Boolean>
Since
1.0
Return-type
Boolean
Description
The logical operator AND returns one of the Boolean constants TRUE, FALSE or NULL, depending on the arguments' values:
- If both arguments result to TRUE, the result is also TRUE.
- If one of the arguments results to FALSE, the result is also FALSE.
- If one of the arguments results to NULL, the result is also NULL.
Instead of this function you also can use the operator "AND".
Examples
AND( TRUE, TRUE )
= TRUE
TRUE and TRUE
= TRUE
AND( FALSE, TRUE )
= FALSE
AND( TRUE, FALSE )
= FALSE
AND( TRUE, NULL )
= NULL
AND( FALSE, NULL )
= NULL
AND( NULL, NULL )
= NULL
See also
NOT, OR
