EVL(EXPRESSION,surrogateCostant or Variable) NVL(EXPRESSION,surrogateCostant or Variable)but if second parameter is slow to evaluate, use IIF(),
IIF(ISNULL(EXPRESSION),surrogateCostant or Variable,EXPRESSION)but if EXPRESSION is slow to evalute or worse, it is not deterministic,
varExp=EXPRESSION IIF(ISNULL(m.varExp),surrogateCostant or Variable,m.varExp)Fabio