This topic has not yet been rated - Rate this topic

NOT (DMX)

SQL Server 2005

SQL Server 2012

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


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

Reference

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

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD