IF expressions

The syntax of the IF expression is as follows:

IF condition 
THEN expression1 
[ ELSE expression2 ] 
ENDIF

This expression returns:

For more information about TRUE, FALSE, and UNKNOWN conditions, see “NULL value” and “Search conditions”.

NoteIF statement is different from IF expression Do not confuse the syntax of the IF expression with that of the IF statement.

For information on the IF statement, see IF statement.