Function Reference > Operators > Logical operators

Logical operators

Use logical operators to manipulate numeric data. Expressions that return a numeric value evaluate to TRUE for values other than 0, FALSE for 0, and NULL for NULL.
The following table lists the transformation language logical operators:
Negates result of an expression. For example, if an expression evaluates to TRUE, the operator NOT returns FALSE. If an expression evaluates to FALSE, NOT returns TRUE.
Joins two conditions and returns TRUE if both conditions evaluate to TRUE. Returns FALSE if one condition is not true.
Connects two conditions and returns TRUE if any condition evaluates to TRUE. Returns FALSE if both conditions are not true.


Expressions that combine a null value with a Boolean expression produce results that are ANSI compliant.
For example, Data Integration produces the following results: