String operators

Table 1 shows the predefined set of operators used for character strings.

Table 1. String Operators for Filtering
Operator	Description
equal to	Use this operator to find and display rows that must match the search term exactly. Note: The search term is not case sensitive.
not equal to	Use this operator to find and display rows that do not match the search term. Note: The search term is not case sensitive.
like	This operator is used to search for a pattern within the column to be filtered. A % (percent) sign is used to specify a wildcard, which matches any character or string of characters. Examples of using the wildcard are: %ing finds any records where the filter value ends in ‘ing’ Bank% finds any records where the filter value starts with the letters ‘Bank’ %ank% finds any records that have the character pattern ‘ank’ anywhere within the field