Connect CDC SQData

The NE (not equal) function determines whether or not two (2) values are not equal to each other. If the values are not equal to each other, a one (1) is returned, otherwise, a zero (0) is returned. The NE function operates in the opposite manner as the EQ (equal) function.

The Less Than/Greater symbols (<>) can also be used to perform this function and is the recommended method.

Category

Boolean

Syntax

NE(value1, value2)

or

value1 <> value2

 

Parameter Descriptions

value1  -  This parameter specifies the first value to be used in the not equal comparison. This value may be a field/column of a source datastore, a constant value, a variable or the result of another Function.

value2  -  This parameter specifies the second value to be used in the not equal comparison. This value may be a field/column of a source datastore, a constant value (i.e. ABC), a variable or the result of another Function.

1 | 0 Indicates whether a TRUE (1) or FALSE (0) was returned from the NE function.

Example

Compare an employee’s yearly salary (YR_WAGE) against their total compensation (TOTAL_COMP) to determine if they are different. If the YR_WAGE and TOTAL_COMP fields are not equal, set variable BONUS to the constant Y. Otherwise, set the variable BONUS to the constant N.

IF YR_WAGE <> TOTAL_COMP

{

   BONUS = 'Y'

}

ELSE

{

   BONUS = 'N'

}