ISNULL
Learn how to use the ISNULL utility function in PlaidCloud Lakehouse. Checks whether a value is NULL. Returns 1 if NULL, 0 otherwise - with syntax and examples.
Checks whether a value is NULL. Returns 1 if NULL, 0 otherwise.
Analyze Syntax
func.isnull(<expr>)
Analyze Examples
func.isnull(None)
┌───┐
│ 1 │
└───┘
SQL Syntax
ISNULL(<expr>)
SQL Examples
SELECT ISNULL(NULL);
┌───┐
│ 1 │
└───┘