Export (0) Print
Expand All

NOT

SQL Server 2000

Negates a Boolean input.

Syntax
[ NOT ] boolean_expression 
Arguments
boolean_expression
Is any valid Boolean expression in Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE).
Result Types

bit

Result Value

NOT reverses the value of any Boolean expression.

Examples

The following example returns a list of all products that have a unit price less than 10 dollars and greater than 100 dollars.

SELECT ProductID, ProductName, UnitPrice 
FROM Products
WHERE UnitPrice NOT BETWEEN 10 AND 100

Show:
© 2014 Microsoft