SQL Server provides two commonly used functions, ISNULL and COALESCE, to address this requirement. Difference Between ISNULL and COALESCE
SQL Server provides two commonly used functions, ISNULL and COALESCE, to address this requirement. Difference Between ISNULL and COALESCE