|
<< Click to Display Table of Contents >> iif() |
  
|
|
<< Click to Display Table of Contents >> 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.