Specifications

Searching the Data Source 69
ID Works Standard and Enterprise Version 5 Operator’s Guide
You can use the Include NULL values option with the Exclude
constraint detail option.
BETWEEN Constraint Rule
Use the BETWEEN rule to find records with values between two
bounding values (and including the bounding values). Example:
where EMPLOYEE.AGE BETWEEN 18 AND 65
Exclude Option
If you select Exclude constraint detail, the search will return all
records with values outside the bounding values you entered. It
applies an SQL NOT to the constraint. Example:
where EMPLOYEE.AGE NOT BETWEEN 18 AND 65
NULL Option
If you select Include NULL values, the search will return all records
with NULL values in addition to records that contain values between
the values you entered. Example: where ((EMPLOYEE.AGE
BETWEEN 18 AND 65) OR (EMPLOYEE.AGE IS NULL))
You can use the Include NULL values option with the Exclude
constraint detail option.
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