IS NOT NULL on a date column

Question

Accepted Answer

IS NOT NULL returns rows where the column has a real value - not missing. Alpha and Gamma both have a deadline set, so they pass. Beta and Delta have NULL deadlines and are excluded. You cannot use != NULL or <> NULL for this check; those expressions evaluate to UNKNOWN and match nothing. IS NOT NULL is the correct and only reliable way to filter for rows that have a date.