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