mvSQL Database Function - ISNULL()¶

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.