Export (0) Print
Expand All
Expand Minimize
1 out of 2 rated this helpful - Rate this topic

NOT (Transact-SQL)

Negates a Boolean input.

Topic link iconTransact-SQL Syntax Conventions


[ NOT ] boolean_expression
boolean_expression

Is any valid Boolean expression.

NOT reverses the value of any 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

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)
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.