NOT (SQL Server Compact Edition)
Negates a Boolean input.
Syntax
[ NOT ] boolean_expression
Arguments
- boolean_expression
Any valid Boolean expression in Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition).
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