iif()

Purpose

To return the result of an expression based on a condition

Syntax

iif( <lCondition> , <expTrue> , <expFalse> ) xValue

Arguments

<lCondition> is a logical expression to be evaluated.

<expTrue>  is the value, of any data type, returned if <lCondition> is true.

<expFalse>  is the value, of any data type, returned if <lCondition> is false.

Returns

iif() returns the evaluation of <expTrue> if <lCondition> evaluates to true and <expFalse> if it evaluates to false.