String Operators

A predefined set of string operators is shown when the filter value selected is represented as a string in the database repository. The string operators are described in Table 1.

Table 1. String Operators
Operator	Description
equal to	Find all records where the search term exactly matches the value in the repository Note: Search term is not case sensitive.
not equal to	Find all records where the search term does not match the value in the repository Note: Search term is not case sensitive.
like	Search for a pattern in a filter field. The percent sign (%) can be used to define wild cards. For example: %ing finds any records where the filter value ends in "ing" Bank% finds any records where the filter value starts with "Bank" %ank% finds any records with the pattern "ank" in the field