SQL Server Transact Basic to Expert - Replace NULL with default value

This blog shows how to replace a NULL value with a default value using ISNULL in SQL Server

Example:

Select Empname, ISNULL(Empsal, 0) from emptable

This will not return any null value of Empsal