Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.