ISNULL scalar function

The ISNULL function returns the first non-null expression in a list of two expressions.

Read syntax diagramSkip visual syntax diagram ISNULL ( expression1 , expression2 )

The schema is SYSIBM.

The ISNULL function is identical to the COALESCE scalar function, except that ISNULL is limited to two arguments.