Specifications

58 Searching the Database
ID Works Basic Version 5 Operator’s Guide
(‘Engineering’, ‘Marketing’, ‘Sales’)) OR (EMPLOYEE.DEPARTMENT
IS NULL)
You can use the Include NULL values option with either or both of
the other options.
IS NULL Constraint Rule
Use the IS NULL rule to find records when the field has no entry.
Example: where EMPLOYEE.LASTNAME IS NULL
No options are available with the IS NULL constraint rule.
IS NOT NULL Constraint Rule
Use the IS NOT NULL rule to match everything but NULL values for
this field. Example: where EMPLOYEE.LASTNAME IS NOT NULL
No options are available with the IS NOT NULL constraint rule.
Numeric Fields
Possible constraints for Production Form auto sequence fields, print
count fields, list fields, and text fields connected to a numeric
database column are:
Constraint Rule Required Detail
Supported Options
Exclude Case Insensitive NULL
= A value Yes No Yes
> A value Yes No Yes
< A value Yes No Yes
BETWEEN Two values Yes No Yes
IN Multi-value
Constraint List
Yes
*
No Yes
IS NULL None No No No
IS NOT NULL None No No No
* Excludes entire list.