OR and AND Functions

Parameters (BOOLEAN value1, BOOLEAN value2);

Returns: BOOLEAN;

These function performs a logical AND or OR operation on the two input parameters to give a Boolean result.

Notes on Use:

• NULL values in the input parameters will be interpreted as FALSE
• String values 'True' and 'Yes' will convert to TRUE. All other string values will convert to false
• Integer values >=1 will convert to TRUE.  All other integer values will convert to false

Examples:             

1. OR(TRUE,FALSE) = TRUE
2. AND(TRUE,FALSE) = FALSE
3. OR(12,0) =TRUE
4. OR(FALSE,0) =TRUE
5. AND(1, 'TRUE') =TRUE
6. AND(NULL,TRUE)= FALSE