Operators

The string operators shown in Table 1 are available for filtering string values.

Table 1. String Operators
Operator	Description
Like	This operator is used to search for a pattern within the filter field. 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