NOT (SQL Server Compact)

  • Article

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