How to filter empty or null records in SQL

You can use CASE or AND statement to filter empty or null records. Recently, I just show something interesting to perform this task using NULLIF.

Cheers! Uma