By default, the Search routine looks for all FILES and produces a listing of the
selected records that match the criteria. In order to narrow your selection,
option boxes are provided. By selecting one or more of these options, the
Search looks for content only within the selected content set.
|
Searching Alphanumeric Values (Strings)
|
|
Criteria
|
Example (Enter in Box)
|
Returns all records
|
|
Equal To
|
Smith
|
with equal values to Smith (Automatic default)
|
|
Begins With
|
Smith%
|
that begins with Smith
|
|
Ends With
|
%Smith
|
that ends with Smith
|
|
Contains
|
%Smith%
|
that contains the character(s) Smith anywhere in the data
|
|
Or
|
('Smith','Simpson')
|
that are equal to Smith or Simpson
|
|
Between Values
|
between 'Sm' and 'Sz'
|
that are greater or equal than 'Sm' and less or equal to 'Sz'
|
|
Searching Numeric Values
|
|
Criteria
|
Example (Enter in Box)
|
Returns all records
|
|
Equal to
|
100
|
with equal values to 100 (Automatic default)
|
|
Not Equal To
|
<> 100
|
that are not equal to 100
|
|
Greater Than
|
> 100
|
that greater than 100
|
|
Greater Or Equal To
|
>= 100
|
that are greater or equal than 100
|
|
Less Than
|
< 01/01/2008
|
that are less than 100
|
|
Less Or Equal To
|
<= 01/01/2008
|
that are less or equal than 100
|
|
Between Numbers
|
between 100 and 200
|
that are greater or equal than 100 and less or equal than 200
|
|
Or
|
(100, 200, 300)
|
that are equal to 100 or 200 or 300
|
|
Searching Dates (MM/DD/YYYY)
|
|
Criteria
|
Example (Enter in Box)
|
Returns all records
|
|
Equal to
|
01/01/2008
|
that are equal to 01/01/2008
|
|
Greater than
|
> 01/01/2008
|
that greater than 01/01/2008
|
|
Greater or Equal to
|
>= 01/01/2008
|
that are greater or equal than 01/01/2008
|
|
Less than
|
< 01/01/2008
|
that are less than 01/01/2008
|
|
Less or Equal to
|
<= 01/01/2008
|
that are less or equal than 01/01/2008
|
|
Not equal To
|
<> 01/01/2008
|
that are not equal to 01/01/2005
|
|
Between Dates
|
between '01/01/2008'AND '01/31/2008'
|
that are greater or equal than '01/01/2008' and less or equal than '01/31/2008'
|
|
|
|
|
|
Search For Missing Data
|
|
Criteria
|
Example (Enter in Box)
|
Returns all records
|
|
Missing or Not there
|
is null
|
that contains no data
|
|
Not Missing
|
is not null
|
that contains data
|
|
*One space between operator and next character. Operators are "=", "IN", "<", ">",
"<>", "BETWEEN"
|