Selecting an Operator


Table of Contents   Previous Page  Next Page    

A criteria entry is composed of a Field, an Operator, and a Value.  For example, "Last Name" "Equals" "Smith" means the field, "Last Name" must be an exact match (equal) when compared to the value "Smith".  Therefore, only members with a last name of Smith will pass the criteria to appear on the report.

The Select Operator window enables you to specify the way the criteria value you choose will be compared to the value of the field in the database.  For example, if the field is "Last Name" and you choose "Not Equal (<>)" for the operator, then whatever value you enter must NOT be in the last name field. i.e., Last Name <> Smith means "no members with a last name of smith"

The list will contain options appropriate to the field chosen. For example, if you choose a freeform text field like "Address Line 1", all options will be available, including the LIKE and NOT LIKE operators for expressions (see below). However, if you choose a field that uses a dropdown list of values (such as Country), the only options will be Equal and Not Equal. As soon as you select an operator, the window will close and the selection will appear on the list.

The following operators may be available:

Equal - indicates that the field data must exactly match the value

Not Equal - indicates that the field data must not match the value

Greater Than - indicates that the field data must be larger than the value.  For numeric values, it means the data must be numerically larger. For text values, it means the data must sort alphabetically after the value. i.e., "> b" means the data must start with "c-z".

Greater Than or Equal - indicates that the field data must be equal to or larger than the value. See "Greater Than".

Less Than - indicates that the field data must be smaller than the value.  For numeric values, it means the data must be numerically lower. For text values, it means the data must sort alphabetically before the value. i.e., "< d" means the data must start with "a, b, or c".

Less Than or Equal - indicates that the field data must be equal to or smaller than the value. See "Less Than".

LIKE - indicates that an expression will be used to match data to a value using the % "wildcard" character. i.e.,  "%smith%" will search for the word "smith" within the data, since the leading and trailing % symbols indicate that any text can come before or after the word.

NOT LIKE -  indicates that an expression will be used to look for non-matching data using the % "wildcard" character. See "LIKE".

RLIKE - Similar to LIKE, but with regular expressions.

NOT RLIKE - Similar to NOT LIKE, but with regular expressions.