Rajendra Gupta has a backup plan in case of NULL:
NULL is a special marker that indicates a missing or undefined value in a column. It is different from zero or an empty string. Handling NULL values is essential for accurate data analysis, data integrity, and error avoidance. This tip explores how to handle NULL values in SQL Server using the COALESCE() function using various queries and reviewing the results.
Click through for a primer on the COALESCE() function, a few use cases for COALESCE(), and how it differs from ISNULL().