IFF$(test_exp, true_exp$, false_exp$)

 

Returns a String Value
Returns the value of true_exp$ if test_exp is true (non-zero). Otherwise, returns false_exp$ if test_exp is false (zero). Use this function to return alpha values. Use the IFF( ) function to return numeric values.

Examples:

IFF$("HELLO WORLD" contains "OR","Hello", "Goodbye")

Returns "Hello".

Other Resources

• Expression Examples
• Filtering Records
• Knowledge Base Article R11493 - All About Expressions
• Knowledge Base Article R11515 - Filter Expression Examples
• Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
• Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)