Skip to main content
Skip table of contents

Choice Functions

You are looking at an older version of the documentation. The latest version is found here.

Choice functions allow you to select from two values based on a characteristic of one of the values.

Function

Definition

Data Type Constraints

COALESCE(x, y+)

Returns the first non-null parameter

x and all y can be any compatible types

IFNULL(x, y)

NVL(x, y)

If x is null, return y; else, return x

x, y, and the return type must be the same type

NULLIF(param1, param2)

If param1 is equal to param2, return NULL; else, return param1

param1 and param2 must be compatible and comparable types

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.