Any suggestions? Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

NOT (SQL Server Compact Edition)

Negates a Boolean input.


[ NOT ] boolean_expression

boolean_expression

Any valid Boolean expression in Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition).

NOT reverses the value of any Boolean expression.

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

Community Additions

ADD
Show:
© 2016 Microsoft