Function: IsEmpty
Description
Returns 1 if the character field is empty, otherwise returns 0 (zero).
Note: If you wish to determine whether a numeric or date field is empty, use the IsNull function.
Syntax
IsEmpty(field)
Arguments
field can be the name of any character field in the table.
Return value
This function returns a number: 1 if the field is empty, 0 (zero) if the field contains data.
Calculated field example
If the Name field contained no value, the following calculated field expression would return a 1, indicating that the field is empty: IsEmpty(Name)
Filter/Find example
Records with a blank Name field can be selected or found using the expression: IsEmpty(Name)=1
© 2024 Altair Engineering Inc. All Rights Reserved.