Example
Test whether an expression is NULL:
SELECT ISNULL(NULL);
Definition and Usage
The ISNULL() function returns 1 or 0 depending on whether an expression is NULL.
If expression is NULL, this function returns 1. Otherwise, it returns 0.
Syntax
ISNULL(expression)