Operator Definitions

Table 1. Operator Definitions
Operator	Action Description
AND	Retrieve records that match both statements. For example, clients whose first name starts with the letter A and live in San Francisco.
OR	Retrieve records that match either of the statements. For example, search for clients whose last name starts with the letter Z or live in Berkeley.
()	Combine expressions to show the order in which the relationships should be grouped. Add parentheses by clicking the + button at the beginning or end of each Boolean statement. Remove parentheses by clicking the x button at the beginning or end of each Boolean statement.
=	Equals to. Retrieve records that contain the specified criteria. For example, clients who have the last name Alvarez.
<>	Does not equal to. Retrieve records that do not contain the specified criteria. For example, clients who do not have the last name Alvarez.
>	Greater than. Retrieve records with numerical values or dates that are bigger than or newer than the specified criteria. For example, client trips that are to be performed tomorrow or in the future.
<	Less than. Retrieve records with numerical values or dates that are smaller than or older than the specified criteria. For example, client trips that were performed yesterday or in the past.
>=	Greater than or equal to. Retrieve records with numerical values or dates that are bigger or newer than or equal to the specified criteria. For example, client trips that are to be performed today and in the future.
<=	Less than or equal to. Retrieve records with numerical values or dates that are smaller or older than or equal to the specified criteria. For example, client trips that were performed today and in the past.
In	Retrieve records that match any value in a group of criteria. For example, clients who use crutches or canes or walkers as mobility aids.
Not In	Retrieve records that do not match any value in a group of criteria. For example, clients who do not use crutches or canes or walkers as mobility aids. The results would list clients who use all other mobility aids.
Begins	Retrieve records using a wildcard search based on values that start at the beginning of the parameter string entered by the user. For example, if the user chooses the Comments field as the search parameter and enters De into the parameter field, the application looks for all Comments that start with De. Note: There is no need for the user to enter any quotations or special characters into the parameter field. The SQL statement automatically updates with a condition like: 'De%'
Not Begins	Retrieve records using a wildcard search based on values that do not start with the parameter string entered by the user. For example, if the user chooses the Comments field as the search parameter and enters De into the parameter field, the application looks for all Comments that do not start with De. Note: There is no need for the user to enter any quotations or special characters into the parameter field.
Ends	Retrieve records using a wildcard search based on values that end with the parameter string entered by the user. For example, if the user chooses the Comments field as the search parameter and enters Le into the parameter field, the application looks for all Comments that end with Le. Note: There is no need for the user to enter any quotations or special characters into the parameter field.
Not Ends	Retrieve records using a wildcard search based on values that do not end with the parameter string entered by the user. For example, if the user chooses the Comments field as the search parameter and enters Le into the parameter field, the application looks for all Comments that do not end with Le. Note: There is no need for the user to enter any quotations or special characters into the parameter field.
Contains	Retrieve records using a wildcard search based on values that contain the parameter string entered by the user. For example, if the user chooses the Comments field as the search parameter and enters mo into the parameter field, the application looks for all Comments that contain mo. In this case, any comments containing the word Simon would be included in the results. Note: There is no need for the user to enter any quotations or special characters into the parameter field.
Not Contains	Retrieve records using a wildcard search based on values that do not contain the parameter string entered by the user. For example, if the user chooses the Comments field as the search parameter and enters mo into the parameter field, the application will look for all Comments that do not contain mo. In this case, any comments containing the word Simon would not be included in the results. Note: There is no need for the user to enter any quotations or special characters into the parameter field.
Is NULL	Retrieve records that are blank or empty for the selected value.
Is Not NULL	Retrieve records that are not blank or empty for the selected value.

AND

Retrieve records that match both statements. For example, clients whose first name starts with the letter A and live in San Francisco.

OR

Retrieve records that match either of the statements. For example, search for clients whose last name starts with the letter Z or live in Berkeley.

()

Combine expressions to show the order in which the relationships should be grouped. Add parentheses by clicking the + button at the beginning or end of each Boolean statement. Remove parentheses by clicking the x button at the beginning or end of each Boolean statement.

=

Equals to. Retrieve records that contain the specified criteria. For example, clients who have the last name Alvarez.

<>

Does not equal to. Retrieve records that do not contain the specified criteria. For example, clients who do not have the last name Alvarez.

>

Greater than. Retrieve records with numerical values or dates that are bigger than or newer than the specified criteria. For example, client trips that are to be performed tomorrow or in the future.

<

Less than. Retrieve records with numerical values or dates that are smaller than or older than the specified criteria. For example, client trips that were performed yesterday or in the past.

>=

Greater than or equal to. Retrieve records with numerical values or dates that are bigger or newer than or equal to the specified criteria. For example, client trips that are to be performed today and in the future.

<=

Less than or equal to. Retrieve records with numerical values or dates that are smaller or older than or equal to the specified criteria. For example, client trips that were performed today and in the past.

In

Retrieve records that match any value in a group of criteria. For example, clients who use crutches or canes or walkers as mobility aids.

Not In

Retrieve records that do not match any value in a group of criteria. For example, clients who do not use crutches or canes or walkers as mobility aids. The results would list clients who use all other mobility aids.

Begins

Retrieve records using a wildcard search based on values that start at the beginning of the parameter string entered by the user. For example, if the user chooses the Comments field as the search parameter and enters De into the parameter field, the application looks for all Comments that start with De.

Note:

There is no need for the user to enter any quotations or special characters into the parameter field.
The SQL statement automatically updates with a condition like: 'De%'

Not Begins

Retrieve records using a wildcard search based on values that do not start with the parameter string entered by the user. For example, if the user chooses the Comments field as the search parameter and enters De into the parameter field, the application looks for all Comments that do not start with De.