Function Description
| Category | Description |
|---|---|
| Syntax | ISNULL(object) |
| Function | Checks whether the object value is empty. If the value is empty, ISNULL returns 1. Otherwise, it returns 0. |
| Parameters | object: the value to test |
| Number of Parameters | 1 |
| Parameter Type | / |
| Return Value Type | Number (0 or 1) |
| Notes | An empty string is treated as empty. A space is not treated as empty. |
Examples
| Formula | Result |
|---|---|
ISNULL(MID("Finemoresoftware",30,5)) | 1 |
ISNULL("") | 1 |
ISNULL(" ") | 0 |