ISNULLOREMPTY

Checks to see if a string is null or empty.

Syntax

bool ISNULLOREMPTY(string value)

Example

If MyColumn is NULL or an empty string return Value2 otherwise return the value in MyColumn.

IF(ISNULLOREMPTY(MyColumn), "Value2", MyColumn)