Use the Operator drop-down list to select an Operator to use in the SQL statement.
The operator you select is inserted into the Where section, which displays your Where clause as it is being built.
For lookup expressions, examples of operators include EQUALS, LIKE, GREATER THAN, IS NULL, CONTAINS, etc.
Use the percent (%) sign with the LIKE operator to find text at the beginning and end of Lookup expressions. For example:
S4 LIKE "Win" + %
Returns: Wind, Winter, and Winthrop
S4 Like % + "ington"
Returns: Lexington, Barrington, and Washington
See also
Using Scalar Functions in Lookup Links