Dealing with NULL Values in SQL | SQL Bits | Kovolff

NULL = No Value

NULL values filtering:
WHERE field_name IS NULL
or
WHERE field_name IS NOT NULL

The COALESCE function replaces NULL values with values of your choice
COALESCE(field_name, null_replacement)

#sql #null #coalesce #replace