Equal = (or ==)

Syntax:

NCDTY value_1 = NCDTY value_2

 

Return Value:

Y result_of_comparison

  
Precedence:5
Description:

This relational operator compares two fields and gives TRUE if they are equal

 

Example:

"SMITH" = "JONES" = FALSE
3.142 = 3.142 = TRUE

 

This operator may not work as expected when used with floating point numbers. Make sure the numbers do not contain any rounding errors by using the round or trunc functions if necessary.