VALUE

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram                         .---------------.
                         V               |
>>-VALUE--(--expression----,--expression-+--)------------------><
 

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 1999 standard.