NULL vs Empty vs Blank

Tell NULL, empty strings and blank whitespace apart in SQL — detecting each one, a combined detection pattern, handling all three with COALESCE and NULLIF, and how they compare and concatenate differently.