Specifications

Searching the Data Source 75
ID Works Standard and Enterprise Version 5 Operator’s Guide
IS NULL Constraint Rule
Use the IS NULL rule to find records when the field has no entry.
Example: where EMPLOYEE.HIREDATE 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 every record without NULL
values for this field. Example:
where MEMBER.TERMDATE IS NOT NULL
No options are available with the IS NOT NULL constraint rule.