VALUE

The VALUE function returns the value of the first non-null expression.

Read syntax diagramSkip visual syntax diagramVALUE(expression ,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.