IsNull() mvSQL database function in Jitterbit App Builder

Summary

Returns the first parameter if not it's null. Otherwise returns the second parameter.

Syntax

ISNULL(<param1>, <param2>)

Parameters

param1

An expression or column which is returned if it's non-null.

param2

The expression or column to return if <value1> is null.

Returns

The first parameter if non-null, otherwise the second parameter.

Examples

ISNULL(Cost, 0)

Returns

0 if Cost is null, otherwise Cost.