<< May I suggest trying set eqnull off I think it will do what you want but am not quite sure. >>
My goal is to develop a column calculation expression that will give the result I need regardless of the SET ZERO setting. Otherwise, I risk having some rows updated when, for whatever reason, the ZERO setting has been changed. Those rows would have the wrong values. -- Larry

