VALUE scalar function

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

Read syntax diagramSkip visual syntax diagramVALUE( expression, expression)

The schema is SYSIBM.

The VALUE function is identical to the COALESCE function. COALESCE should be used for conformance to SQL standard. For more information, see COALESCE scalar function.