The NVL function returns the first argument that is not null. ==>NVL(expression1, expression2) The arguments are evaluated in the order in which they are specified, and the result of the function is the first argument that is not null. The result can be null only if all the arguments can be null, and the result … Continue reading NVL and COALESCE Functions Basic Differences in DB2