Specifications

Searching the Database 57
ID Works Basic Version 5 Operator’s Guide
Exclude Option
If you select Exclude constraint detail, the search will return all the
values that do not match the constraint detail. Example:
where EMPLOYEE.LASTNAME <> ‘Jones’
Case Insensitive Option
This option has no effect because Access databases provide this
option natively.
NULL Option
The Include NULL values option provides a way to include records
when the field has no entry in addition to the other values you are
searching for. Example: where ((EMPLOYEE.LASTNAME = ‘Jones’)
OR (EMPLOYEE.LASTNAME IS NULL))
You can use the Include NULL values option with either or both of
the other options.
IN Constraint Rule
Use the IN rule when you need to match several distinct values.
Example: where EMPLOYEE.LASTNAME IN (Jones, Li, Garcia)
Exclude Option
If you select Exclude constraint detail, the search will return all the
values that do not appear anywhere on the list. It applies an SQL
NOT to the constraint. Example: where EMPLOYEE.DEPARTMENT
NOT IN (‘Engineering’, ‘Marketing’, ‘Sales’)
Case Insensitive Option
This option has no effect because Access databases provide this
option natively.
NULL Option
The Include NULL values option provides a way to include records
when the field has no entry in addition to the other values you are
searching for. Example: where (EMPLOYEE.DEPARTMENT IN