IS NULL
Find missing values without confusing them with empty text.
Try an expression
In Formula, enter the expression and set Output type to BOOLEAN.
Example input
- Row 1
email = 'ada@example.com' - Row 2
email = NULL - Row 3
email = ''
Expression
email IS NULLResult
Row 1: false
Row 2: true
Row 3: falseNULL means the value is missing.
This Boolean expression also works in Filter custom mode. The True output receives rows 2; the False output receives rows 1, 3. A missing result goes to False.
Arguments and types
expr IS NULLThe result type can depend on the input types. See DuckDB for the full argument rules.
Function metadata from DuckDB, used under the MIT license.