The VALUE function returns the value of the first non-null expression.
The VALUE function is identical to the COALESCE scalar function. For more information, see COALESCE.
Syntax alternatives: COALESCE should be used for conformance to the SQL 1999 standard.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.