Skip to Content

Turn your connections into holiday cash with our new Customer Referral Program! Learn more

✕

This documentation is for version 4 of App Builder, the new name for Vinyl. Access the Vinyl documentation here.

✕

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.