Icon Boolean Operators

The following are the boolean operators in ElevateDB, ordered by their operator precedence:

OperatorDescription
NOTFlips a boolean expression so that True becomes False, or vice-versa.
ANDReturns True if both the left and right boolean expressions are True.
ORReturns True if either the left or right boolean expression is True.

Examples
-- The following SQL uses the AND Boolean
-- operator to select all shipped orders
-- placed within the last 100 days

SELECT *
FROM Orders
WHERE OrderDate >= CURRENT_DATE-100 AND
ShipDate IS NOT NULL

SQL 2003 Standard Deviations
The following areas are where ElevateDB deviates from the SQL 2003 standard:

DeviationDetails
None
Image