AND (DMX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Data Mining Extensions (DMX) Operator Reference
Logical Operators (DMX)
Operators (DMX)