True

Perform a case-sensitive text search.

False

A case-sensitive search is not performed.

Is Equal To

An exact match is required.

Microsoft SQL Server only.  If the underlying database field selected for the search operation is a Microsoft SQL Server 'char' data type, the actual value stored includes blanks padded at the end of the string.  As such, text strings entered into the search control will not match the char data type field, because the search control strips the trailing spaces from the search string.

CONTAINS

The database field must contain the search string.

STARTS_WITH

The database field must start with the search string.

ENDS_WITH

The database field must end with the search string.