TIBCO EBX®
Documentation > Developer Guide > SQL in EBX®
Navigation modeDocumentation > Developer Guide > SQL in EBX®

Logical operators

The table below lists all 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®