Used to perform a logical conjunction on two expressions.
result = expression1 And expression2
The And operator syntax has these parts:
Part | Description |
---|---|
result | Any numeric value. |
expression1 | Any expression. |
expression2 | Any expression. |
If, and only if, both expressions evaluate to True, result is True. If either expression evaluates to False, result is False. The following table illustrates how result is determined:
If expression1 is | And expression2 is | The result is |
---|---|---|
True | True | True |
True | False | False |
True | Null | Null |
False | True | False |
False | False | False |
False | Null | False |
Null | True | Null |
Null | False | False |
Null | Null | Null |
The And operator also performs a bitwise comparison and sets the corresponding bit in result according to the following table:
If the bit in expression1 is | And the bit in expression2 is | The result is |
---|---|---|
0 | 0 | 0 |
0 | 1 | 0 |
1 | 0 | 0 |
1 | 1 | 1 |