How I Learned to Stop Worrying and Love NULL in SQL

The appropriate SQL function should be used to avoid getting undesired output for operations such as data concatenation, comparison, ORDER BY, or GROUP BY. You should not try to prevent NULL values - instead, write your query in a way to overcome its limitations.