The NULL function replaces NULL values with a specified value, commonly using ISNULL(), IFNULL(), or COALESCE(), depending on the database type. Below is an example of a SQL Server query for better understanding.
SELECT ISNULL(salary, 0) AS Salary FROM employees;