Connect CDC SQData

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)

 

Parameter Descriptions

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'

}