NOT (SQL Server Compact)
Negates a Boolean input.
Syntax
[ NOT ] boolean_expression
Arguments
- boolean_expression
Any valid Boolean expression in Microsoft SQL Server Compact.
Result Types
bit
Return Value
NOT reverses the value of any Boolean expression.
Example
The following example returns a list of all products that have a unit price less than 10 dollars and more than 100 dollars.
SELECT ProductID, ProductName, UnitPrice
FROM Products
WHERE UnitPrice NOT BETWEEN 10 AND 100