The syntax of the IF expression is as follows:
IF condition THEN expression1 [ ELSE expression2 ] ENDIF
This expression returns the following:
If condition is TRUE, the IF expression returns expression1.
If condition is FALSE, the IF expression returns expression2.
If condition is FALSE, and there is no expression2, the IF expression returns NULL.
If condition is NULL, the IF expression returns NULL.
For more information about TRUE, FALSE and UNKNOWN conditions, see “NULL value” and “Search conditions”.
IF 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.
