Returns the boolean value true if the value passed to the function is a null else returns false.
= ISNULL(value)
Value |
A value which has to be checked. The value can be specified as a decimal value (e.g., 37.48), as a string (“True”), as a Boolean (e.g., True), as an expression (e.g., 1+1=2), or as the value of a variable (e.g, UnitPrice). |
Boolean
Example |
Returns |
= ISNULL(“a”) |
False |
= ISNULL(1234) |
False |
= ISNULL(1+1=2) |
False |
= ISNULL(UnitPrice) |
True if the value of UnitPrice is null else returns false |