DB2 VALUE functions

DB2 VALUE function www.2cto.com Syntax: VALUE (EXPRESSION1, EXPRESSION2) VALUE function is to return a non-empty VALUE, when the first parameter is not empty, directly return the value of this parameter. If the first parameter is null, the value of the first parameter is returned. Select value (ID, '') FROM T1 indicates that if T1.ID is null, an empty string is returned. If T1.ID is not empty, T1.ID is returned. When you need to calculate the field value, for example, www.2cto.com where amt1 + amt2> 0, if the value amt1 or amt2 is NULL, the result is wrong, and the value function is displayed. Where value (amt1, 0) + value (amt2, 0)> 0.