IF

Specifies a logical test to perform.

Syntax

object    IF(bool? condition, object trueValue, object falseValue)
bool      IF(bool? condition, bool trueValue, bool falseValue)
string    IF(bool? condition, string trueValue, string falseValue)
string[]  IF(bool? condition, string[] trueValue, string[] falseValue)
byte?     IF(bool? condition, byte? trueValue, byte? falseValue)
byte[]    IF(bool? condition, byte[] trueValue, byte[] falseValue)
short?    IF(bool? condition, short? trueValue, short? falseValue)
int?      IF(bool? condition, int? trueValue, int? falseValue)
int[]     IF(bool? condition, int[] trueValue, int[] falseValue)
long?     IF(bool? condition, long? trueValue, long? falseValue)
double?   IF(bool? condition, double? trueValue, double? falseValue)
decimal?  IF(bool? condition, decimal? trueValue, decimal? falseValue)
Single?   IF(bool? condition, Single? trueValue, Single? falseValue)
DateTime? IF(bool? condition, DateTime? trueValue, DateTime? falseValue)
Guid?     IF(bool? condition, Guid? trueValue, Guid? falseValue)

Inputs

Object Description
condition The logical test.
trueValue The value if true.
falseValue The value if false.

Example

If Value1 is NULL or an empty string return Value2.

IF(ISNULLOREMPTY(Value1), Value2, Value1)