Replace a value with an alternative if it is NULL

Replaces the focal input with the alternative value if it is NULL.

ifnull(x = NULL, alt = NULL)

Arguments

x	Focal input.
alt	Alternative value.

Value

x if not NULL, alt otherwise.

Examples

 ifnull(NULL, 123)
 ifnull(TRUE, 123)
 ifnull(FALSE, 123)