Data Synchronisation StudioUser GuideCalculated ColumnsFunctionsISNULLOREMPTYOn this pageISNULLOREMPTY 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)