Links
Comment on page

Logical-and &, and

Operator: & , and
The logical operator & (and) checks if two conditions both evaluate to true. The operators & and and can both be used and are exactly the same.
If used together with the logical or 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.
The result is a Yes/No value, depending on the check
  • if Condition1 evaluates to true AND Condition2 evaluates to true, only then Yes is returned.
  • all other evaluations result in No
condition1 & condition2
(6=6) & ("Hello world" = "Hello world") => Yes
false & false => No
false & true => No
true & true => Yes
true & "text" => expression type mismatch
condition1 and condition2
(6=6) and ("Hello world" = "Hello world") => 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