IFNULL

Returns values dependent on if input values are null or not

IFNULL( value )

Returns specified value if a value is null, returns specified else value otherwise.

Arguments

Argument	Description
value	Value or column potentially containing nulls
then	Value to return if value is null
else	Value to return if value is not null

Output

Outputs a series of values depending on if an element is null or not

Example