VALUE
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.
Note
Syntax alternatives: COALESCE should be used for conformance to the SQL 2003 standard.