ISNULL — Test for NULL
The ISNULL and other operators shown here are used to test for NULL or non-NULL expressions. They are syntactic variations on IS NULL and IS NOT NULL, which are properly formed IS expressions.
ISNULL
IS NULL
IS NOT NULL
IS