HP Intelligent Management Center Standard Software Platform - Manual (Page 474)

Filter created Select Example
Values to re-
trieve
Not Be-
tween 25 and 36
Not between
Retrieve all the
weeks of the
year, except for
weeks 25 through
36 (week 25 and
week 36 are not
included).
Values outside
the range of two
values you speci-
fy.
In list
'US; Japan; UK'
In list
Retrieve data for
only the following
countries: the US,
Japan, and the
UK.
Values that are
the same as sev-
eral values you
specify.
Not in
list 'US; Japan;
UK'
Not in list
Don't retrieve da-
ta for the follow-
ing countries: the
US, Japan, and
the UK.
Values that are
different from the
multiple values
you specify.
Is null Is null
Retrieve cus-
tomers without
children (the chil-
dren column in
the database has
no data entry).
Values for which
there is no value
entered in the
database.
Is not
Null
Is not Null
Retrieve cus-
tomers with chil-
dren (the children
column in the
database has a
data entry).
Values for which
a value was en-
tered in the
database.
474 Crystal Reports 2008 SP3 User's Guide
Building Queries 18
Query filters and prompts