| Excerpt |
|---|
The ISNULL function tests whether a column of values contains null values. For input column references, this function returns true or false. |
- The
NULL function generates null values. See NULL Function. - Null values are different from missing values.
- For more information on null values, see Manage Null Values.
| D code |
|---|
delete row:ISNULL(Qty) |
Output: Deletes any row in which the value in the Qty column is null.
| D code |
|---|
delete value:ISNULL(column_string) |
| Argument | Required? | Data Type | Description |
|---|
| column_string | Y | string | Name of column or string literal to be applied to the function |
column_string
Name of the column or string literal to be tested for null values.
- Missing literals or column values generate missing string results.
- Multiple columns and wildcards are not supported.
| Required? | Data Type | Example Value |
|---|
| Yes | String literal or column reference | myColumn |
Valid data type strings:
| Include Page |
|---|
| Valid Data Type Strings |
|---|
| Valid Data Type Strings |
|---|
|
Example - Type check functions
| Include Page |
|---|
| EXAMPLE - Type Functions |
|---|
| EXAMPLE - Type Functions |
|---|
|
