Examples of expressions that use a blank field's value (Null or zero-length string) as criteria

Examples of expressions that use a blank field's value (Null or zero-length string) as criteria

To learn more about how to use Null values and zero-length strings, click .

Field Expression Description
ShipRegion Is Null Displays orders for customers whose ShipRegion field is Null (blank).
ShipRegion Is Not Null Displays orders for customers whose ShipRegion field contains a value.
Fax " " Displays orders for customers who don't have a fax machine, indicated by a zero-length string value in the Fax field instead of a Null (blank) value.