ISNULL()

Return the specified value IF the expression is NULL, otherwise return the expression.


SELECT 
    ISNULL(NULL,20) result;

Output:
20

SELECT 
    ISNULL('Hello', 'Hi') Result;

Output:
Hello