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
.