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 3.5 (SQL Server Compact 3.5).

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