Results for “NULL”
Small, practical examples. Search by task or narrow things down below.
Archive filenames safely with null delimiters
Linux Commands: Use find -print0 with tar --null to preserve spaces and embedded newlines in filenames.
Linux Commands✓ Tested
Bind a typed nonnullable FormControl
Bind a typed nonnullable FormControl with a standalone Angular component and explicit browser behavior.
Angular✓ Tested
Distinguish row count from non-null value count
SQL: COUNT(*) includes every row while COUNT(column) skips NULL values.
SQL✓ Tested
Distinguish row count from non-null value count
SQL Server: COUNT(*) includes every row while COUNT(column) skips NULL values.
SQL Server✓ Tested
Distinguish row count from non-null value count
Postgres: COUNT(*) includes every row while COUNT(column) skips NULL values.
Postgres✓ Tested
Distinguish row count from non-null value count
SQLite: COUNT(*) includes every row while COUNT(column) skips NULL values.
SQLite✓ Tested
Find missing values with IS NULL
SQL: Use IS NULL rather than equality to test for missing data.
SQL✓ Tested
Find missing values with IS NULL
SQL Server: Use IS NULL rather than equality to test for missing data.
SQL Server✓ Tested
Find missing values with IS NULL
Postgres: Use IS NULL rather than equality to test for missing data.
Postgres✓ Tested
Find missing values with IS NULL
SQLite: Use IS NULL rather than equality to test for missing data.
SQLite✓ Tested
Provide a fallback for a nullable value
C#: The null-coalescing operator supplies a default only when the left side is null.
C#✓ Tested
Read null-delimited filenames into an array
Bash Scripts: A null delimiter preserves spaces and embedded newlines in filenames.
Bash Scripts✓ Tested