Specifications

Searching the Database 61
ID Works Basic Version 5 Operator’s Guide
IN Constraint Rule
Use the IN rule to match multiple values. Example:
where EMPLOYEE.DNMBR IN (716, 729, 766)
Exclude Option
If you select Exclude constraint detail, the search will return all the
records with values that do not appear anywhere on the list. It applies
an SQL NOT to the constraint. Example: where EMPLOYEE.DNMBR
NOT IN (716, 729, 766)
NULL Option
If you select Include NULL values, the search will return all records
with NULL values in addition to records that contain values you
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.