IF(criteria_exp,then_exp,else_exp)

Returns then_exp if criteria_exp evaluates to a non-zero value.

If criteria_exp evalulates to zero, then the function returns else_exp.

Example:

Select If(1, 'YES', 'NO')

Returns: YES

Example:

Select If(0, 'YES', 'NO')

Returns: NO