Specifications

70 Searching the Data Source
ID Works Standard and Enterprise Version 5 Operator’s Guide
entered. Example: where ((EMPLOYEE.DNMBR IN (716, 729, 766))
OR (EMPLOYEE.DNMBR IS NULL))
You can use the Include NULL values option with the Exclude
constraint detail option.
IS NULL Constraint Rule
Use the IS NULL rule to find records when the field has no entry.
Example: where CARD.PRINTCOUNT 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 CARD.PRINTCOUNT IS NOT NULL
No options are available with the IS NOT NULL constraint rule.