Function: IsEmpty


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.




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.

Intellectual Property Rights Notice | Technical Support