Use Case – Handling NULLs

Handle NULLs with the SQL CASE statement — CASE versus NULL functions, detecting NULLs, default values, NULLs in calculations, data completeness flags, multiple NULL columns and NULL-aware sorting.