System SQL Functions

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

For the latest version of JMP Help, visit JMP.com/help.

•

Function	SQLite	Description
COALESCE( arg1,..., argN )	Yes	Returns the first argument passed to it that is non-NULL. Returns NULL if all arguments are NULL. Requires at least two arguments.
IFNULL( arg1, arg2 )	Yes	Returns arg1 if not NULL, otherwise arg2. Basically, IFNULL is a two-argument version of COALESCE().
NULLIF( arg1, arg2 )	Yes	Returns arg1 if arg1 and arg2 are different and returns NULL if the arguments are equal. Used when you have non-NULL values in your database that you want to treat as NULL.

•

Help created on 3/19/2020