Manipulating Values $-$ Dealing with NULL values

It is often undesirable for NULLs to appear in our final dataset in our reports. It can be helpful to remove

them entirely or replace them with another value.

Which function is used to return an alternative value when an expression is NULL in SQL Server?

ISNULL

BLANK

IFNULL

NOTNULLx