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
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