Cloud Software Group, Inc. EBX®
Documentation > Developer Guide > SQL in EBX®
Navigation mode Documentation > Developer Guide > SQL in EBX®

# Logical operators

The following table lists all of the SQL logical operators supported by EBX®, along with their standard SQL syntax.

Operator syntax | Description and example(s)
--- | ---
boolean1 OR boolean2 | Whether boolean1 is TRUE or boolean2 is TRUE `SELECT TRUE OR TRUE : true` `SELECT TRUE OR FALSE : true` `SELECT FALSE OR TRUE : true` `SELECT FALSE OR FALSE : false`
boolean1 AND boolean2 | Whether boolean1 is TRUE and boolean2 is TRUE `SELECT TRUE AND TRUE : true` `SELECT TRUE AND FALSE : false` `SELECT FALSE AND TRUE : false` `SELECT FALSE AND FALSE : false`
NOT boolean | Whether boolean is not TRUE; returns UNKNOWN if boolean is UNKNOWN `SELECT NOT TRUE : false` `SELECT NOT FALSE : true` `SELECT NOT UNKNOWN : null`
boolean IS FALSE | Whether boolean is FALSE; returns FALSE if boolean is UNKNOWN `SELECT TRUE IS FALSE : false` `SELECT FALSE IS FALSE : true`
boolean IS NOT FALSE | Whether boolean is not FALSE; returns TRUE if boolean is UNKNOWN `SELECT TRUE IS NOT FALSE : true` `SELECT FALSE IS NOT FALSE : false`
boolean IS TRUE | Whether boolean is TRUE; returns TRUE if boolean is UNKNOWN `SELECT TRUE IS TRUE : true` `SELECT FALSE IS TRUE : false`
boolean IS NOT TRUE | Whether boolean is not TRUE; returns FALSE if boolean is UNKNOWN `SELECT TRUE IS NOT TRUE : false` `SELECT FALSE IS NOT TRUE : true`
boolean IS UNKNOWN | Whether boolean is UNKNOWN `SELECT TRUE IS UNKNOWN : false` `SELECT FALSE IS UNKNOWN : false`
boolean IS NOT UNKNOWN | Whether boolean is not UNKNOWN `SELECT TRUE IS NOT UNKNOWN : true` `SELECT FALSE IS NOT UNKNOWN : true`

Documentation > Developer Guide > SQL in EBX®