Icon Boolean Types

Boolean types are used to represent the values of True or False.

TypeDescription
BOOLEAN
BOOL
A logical true/false value.

Literals
Boolean literals are expressed as the literals TRUE and FALSE (case-insensitive) or 1 and 0 for TRUE and FALSE, respectively.

Literal Examples
-- This example specifies a BOOLEAN literal

SELECT * FROM Customer WHERE SpecialAttention=TRUE

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

DeviationDetails
None
Image