The NOT (logical NOT) function reverses the result of a Boolean Connect CDC SQData function. In other words, the NOT function returns the opposite of a Boolean function. If the Boolean function within the NOT is true (1), a zero (0) is returned. Otherwise, a false (0) is returned.
Category
Boolean
Syntax
NOT(boolean_functions)
Parameters and Descriptions
| Parameter | Description |
|---|---|
| boolean_functions | One (1) or more Boolean Connect CDC SQData functions. |
| 1 | 0 | Indicates whether a TRUE (1) or FALSE (0) was returned from the NOT function. |
Example
If neither an employee’s annual salary (YR_WAGE) is greater than $75,000 nor the employee’s bonus (BONUS) is greater than $25,000, set variable EMPL_COST to the constant OK. Otherwise, set the variable EMPL_COST to the constant CHECK.
IF NOT(YR_WAGE > '75000' AND BONUS > '25000') = 1
{
EMPL_COST = '0K'
}
ELSE
{
EMPL_COST = 'CHECK'
}