AND (DMX)
Performs a logical conjunction on two numeric expressions.
Syntax
Expression1 AND Expression2
Parameters
- Expression1
A valid Data Mining Extensions (DMX) expression that returns a numeric value.
- Expression2
A valid DMX expression that returns a numeric value.
Return Value
A Boolean value that returns TRUE if both parameters evaluate to TRUE; otherwise FALSE.
Remarks
Both parameters are treated as Boolean values (0 as FALSE; otherwise TRUE) before the operator performs the logical conjunction. The following table lists the values that are returned based on the various combinations of parameter values.
| If Expression1 is | If Expression2 is | Return value is |
|---|---|---|
TRUE |
TRUE |
TRUE |
TRUE |
FALSE |
FALSE |
FALSE |
TRUE |
FALSE |
FALSE |
FALSE |
FALSE |
See Also
Reference
Data Mining Extensions (DMX) Operator Reference
Logical Operators (DMX)
Operators (DMX)