Negates a Boolean input.
.gif)
Transact-SQL Syntax Conventions
[ NOT ] boolean_expression
-
boolean_expression
-
Is any valid Boolean expression.
Using NOT negates an expression.
The following table shows the results of comparing TRUE and FALSE values using the NOT operator.
|
|
NOT
|
|---|
|
TRUE
|
FALSE
|
|
FALSE
|
TRUE
|
|
UNKNOWN
|
UNKNOWN
|
Boolean
NOT reverses the value of any Boolean expression.
The following example finds all Silver colored bicycles that do not have a standard price over $400.
USE AdventureWorks;
GO
SELECT ProductID, Name, Color, StandardCost
FROM Production.Product
WHERE ProductNumber LIKE 'BK-%' AND Color = 'Silver' AND NOT StandardCost > 400;
GO
Here is the result set.
ProductID Name Color StandardCost
--------- ------------------- ------ ------------
984 Mountain-500 Silver, 40 Silver 308.2179
985 Mountain-500 Silver, 42 Silver 308.2179
986 Mountain-500 Silver, 44 Silver 308.2179
987 Mountain-500 Silver, 48 Silver 308.2179
988 Mountain-500 Silver, 52 Silver 308.2179
(6 row(s) affected)
Reference
Expressions (Transact-SQL)
Functions (Transact-SQL)
Operators (Transact-SQL)
SELECT (Transact-SQL)
WHERE (Transact-SQL)
Other Resources
Logical Operators
Help and Information
Getting SQL Server 2008 Assistance