Specifications

66 Searching the Data Source
ID Works Standard and Enterprise Version 5 Operator’s Guide
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.DEPARTMENT IN (‘ENGINEERING’,
‘MARKETING’, ‘SALES’)
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.DEPARTMENT IN
(‘Engineering’, ‘Marketing’, ‘Sales’)) OR (EMPLOYEE.DEPARTMENT
IS NULL)
You can use the Include NULL values option with either or both of
the other options.
IS NULL Constraint Rule
Use the IS NULL rule to find records when the field has no entry.
Example: where EMPLOYEE.LASTNAME IS NULL
No options are available with the IS NULL constraint rule.
IS NOT NULL Constraint Rule
Use the IS NOT NULL rule to match everything but NULL values for
this field. Example: where EMPLOYEE.LASTNAME IS NOT NULL
No options are available with the IS NOT NULL constraint rule.