The following logical operators can be used with the Search function:
Operator / Context / Operation
~ / Alone in field / Blank Field
~ - Finds records where the field is blank.
* / Before search string / Contains
*Paper - Finds records where the field contains the word Paper.
* / After search string / Begins with
Paper* - Finds records where the field begins with Paper.
! / Before search string / Does not contain
!Paper - Finds records where the field does not contain the word Paper.
> / Before search string / Is greater than
>Steno - Finds records where the field follows the word Steno.
>100 - Finds records where the field is greater than 100.
< / Before search string / Is less than
<Steno - Finds records where the field precedes the word Steno.
<100 - Finds records where the field is less than 100.
= / Before search string / Is equal to
=Steno - Finds records where the field equals the word Steno.
Steno - Finds records where the field equals the word Steno.
Note: The = sign is optional. The record must match exactly. Differences between upper or lower case characters are ignored.
AND / Space before and after / And
*Steno AND *White - Finds records where the field contains both the word Steno and the word White.
*Steno = contains Steno.
*White = contains White.
*Steno AND *White = contains Steno AND contains White.
OR / Space before and after / Or
*Steno OR *White - Finds records where the contents of the field contains either the word Steno or the word White.
*Steno = contains Steno.
*White = contains White.
*Steno OR *White = contains Steno OR contains White.
See:
Database Manager Contents