Specifications

Searching the Data Source 65
ID Works Standard and Enterprise 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
D You can use
the exclude and
case-insensitive
options together
to exclude a
value regardless
of whether it is
uppercase or
lowercase.
The Match text case-insensitive option provides a way to find
matches without worrying about whether each character is uppercase
or lowercase. It converts the constraint detail text to uppercase and
uses the SQL UPPER function on the column. Example:
where UPPER(EMPLOYEE.LASTNAME) = ‘JONES’
Some databases, such as Access, provide this option natively. For
those databases, this option has no effect.Some databases, such as
Access, 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’)