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


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: