IFNULL Operation

How to use the IFNULL operation for Computed Attributes

Definition

The IFNULL operation allows you to define the output for a field that is null.

Example

IFNULL(NULL, Not Defined)

Result:
Not Defined

Syntax Guide

IFNULL(value1, value_if_null)

value1 - The value to test

value_if_null- The value to return if value1 is NULL