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 and displays rows where the value in the column to be filtered ends in "ing". `Bank%` finds and displays rows where the value in the column to be filtered starts with the letters "Bank". `%ank%` finds and displays rows that have the character pattern "ank" anywhere within the value in the column to be filtered .