User`s guide

Filter createdSelectExampleValues to retrieve
<Country> Not in list
'US; Japan; UK'
Not in list
Don't retrieve data for
the following countries:
the US, Japan, and the
UK.
Values that are differ-
ent from the multiple
values you specify.
<Children> Is nullIs null
Retrieve customers
without children (the
children column in the
database has no data
entry).
Values for which there
is no value entered in
the database.
<Children> Is not NullIs not Null
Retrieve customers
with children (the chil-
dren column in the
database has a data
entry).
Values for which a val-
ue was entered in the
database.
<DOB> Matches pat-
tern, '72'
Matches pattern
Retrieve customers
whose date of birth is
1972.
Values that includes a
specific string.
<DOB> Different from
pattern, '72'
Different from pattern
Retrieve customers
whose date of birth is
not 1972.
Values that don't in-
clude a specific string.
<Account Type> Both
"fixed" and "mobile"
Both
Retrieve Telco cus-
tomers who have both
a fixed telephone and
a mobile phone.
Values that correspond
to two values you
specify.
<Account Type> "fixed"
Except "mobile"
Except
Retrieve Telco cus-
tomers who have a
fixed telephone, but
don't have a mobile
phone.
Values that correspond
to a single value and
do not correspond to
another value you
specify.
2012-03-14353
Building Queries