empty()

Examples


The empty() function returns a value indicating whether a field is empty.

Syntax

empty(field_name)

Parameters

field_name – The name of the field being checked.

Return value

Boolean

Comments

Numeric fields are considered empty if they contain a value of 0. String fields are considered to be empty if they contain nothing or only spaces. Date fields are considered empty when the date value is 0/0/0. Time fields are considered empty when the time value is 12:00:00 AM, which corresponds to 000000.


Documentation Feedback