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)