DB2 Version 9.7 for Linux, UNIX, and Windows

VALUE scalar function

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

The schema is SYSIBM.

The VALUE function returns the first argument that is not null.

VALUE is a synonym for COALESCE.