Specifications

68 Searching the Data Source
ID Works Standard and Enterprise Version 5 Operator’s Guide
You can use the Include NULL values option with the Exclude
constraint detail option.
> Constraint Rule
Use the > rule to find records with values greater than the value
entered (that is, more positive). Example: where EMPLOYEE.AGE >
65
Exclude Option
If you select Exclude constraint detail, the search will return all
records with values less than or equal to the value you entered.
Example: where EMPLOYEE.AGE <= 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 greater
than the value you entered. Example: where ((EMPLOYEE.AGE >
65) OR (EMPLOYEE.AGE IS NULL))
You can use the Include NULL values option with the Exclude
constraint detail option.
< Constraint Rule
Use the < rule to find records with values less than the value entered
(less positive). Example: where EMPLOYEE.AGE < 18
Exclude Option
If you select Exclude constraint detail, the search will return all
records with values greater than or equal to the value you entered.
Example: where EMPLOYEE.AGE >= 18
NULL Option
If you select Include NULL values, the search will return all records
with NULL values in addition to records that contain values less than
the value you entered. Example: where ((EMPLOYEE.AGE < 18) OR
(EMPLOYEE.AGE IS NULL))