Specifications

Searching the Database 59
ID Works Basic Version 5 Operator’s Guide
= Constraint Rule
Use the = rule to match an exact value. Example:
where EMPLOYEE.DNMBR = 716
Exclude Option
If you select Exclude constraint detail, the search will return all
records with values that do not match the value you entered.
Example: where EMPLOYEE.DNMBR <> 716
NULL Option
If you select Include NULL values, the search will return all records
with NULL values in addition to records that contain the value you
entered. Example: where ((CARD.PRINTCOUNT = 0) OR
(CARD.PRINTCOUNT 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 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.