NOT (TSQL Operator)
Performs a logical NOT of a boolean expression.
Syntax
NOT bool_expr
Arguments
- bool_expr
- is an expression of type
bool
.
Such expression can be produced e.g. by comparison operators like=
,>
, etc.
Return Types
Returns a result of type bool
.
Remarks
In SQL, logical operators evaluate to True, False or NULL, with a 3-valued logic.
This table shows the results for the logical NOT
operator.
NOT | |
---|---|
True | False |
False | True |
NULL | NULL |
Examples
PRINT NOT 1=1;
PRINT NOT 1=2;
PRINT NOT 1=NULL;
The result is:
false
true
<NULL>