IFF() Function - Test True/False Expression

Syntax

IFF (num_expr,true_str,false_str)

Description

The IFF() function tests a specified numeric expression and returns one of two strings, based on whether the expression tested was true or false.

Example

Select IFF(curr_bal>0,'Yes','No'), last_name from customer



______________________________________________________________________________________

Copyright BASIS International Ltd. BBj®, Visual PRO/5®, PRO/5®, and BBx® are registered trademarks.