Scalar. Determines if an expression is NULL.
isnull ( expression )
| expression | An expression of any datatype. |
Determines if an expression is NULL. The function can take any datatype as its argument, and the function returns an integer. The function returns 1 if the argument is NULL, and 0 otherwise.
isnull ('examplestring') returns 0.