Specifications

60 Searching the Database
ID Works Basic Version 5 Operator’s Guide
< 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))
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.