NOT (DMX)

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

A logical operator that performs a logical negation on a numeric expression.

Syntax


NOT Expression1  

Parameters

Expression1
A valid DMX expression that returns a numeric value.

Return Value

A Boolean value that returns FALSE if the argument evaluates to TRUE; otherwise FALSE.

Remarks

The argument is treated as a Boolean value (0 as FALSE; otherwise TRUE) before the operator performs the logical negation. If Expression1 is TRUE, the operator returns FALSE. If Expression1 is FALSE, the operator returns TRUE. The following table illustrates how the logical conjunction is performed.

If Expression1 is Return value is
TRUE FALSE
FALSE TRUE

See Also

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