The “COALESCE” function is one of the frequently used functions in DB2. Before going into detail, I just want to describe it in layman terms. RelatedNVL and COALESCE Functions Basic Differences in DB2 This function validates for NULL, and secondly, if NULL is there it assumes some value as we give in the function. Syntax: COALESCE(epression1,expression2) It is like … Continue reading DB2- Use of ‘COALESCE’ Function (1 of 2)