--Replacing NULL value using ISNULL() function: We are passing 2 parameters to IsNULL() function. --If M.Name returns NULL, then 'No Manager' string is used as the replacement value.