Does handling the possibility of NULLS in the formula help isnull(x,' ') Also CONCAT_WS may help with the tidying