Checks to see if a string is null or empty.
bool ISNULLOREMPTY(string value)
If Value1 is NULL or an empty string return Value2.
IF(ISNULLOREMPTY(Value1), Value2, Value1)