SQL - Boolean


The Boolean data type in SQL is a Three-valued logic (3VL) boolean with:

  • true
  • false
  • and unknown (Stored with a SQL Null)

In SQL, the unkown is the output of a comparisons with the NULL value where null is not equal to null


The string key words TRUE and FALSE are the SQL-compliant string representation.

Documentation / Reference

Powered by ComboStrap