Add a pattern match (LIKE) predicate to an SQL statement

The pattern match (LIKE) predicate searches for strings that have a certain pattern. Trailing blanks in a pattern are part of the pattern.

You can use wildcard characters to modify a search for a particular string pattern in some SQL predicates. SQL Assist supports the following wildcard characters, as described below.

These steps are part of the larger task of adding search conditions to an SQL statement (WHERE or HAVING clause). When you complete the steps for adding a simple comparison predicate to an SQL statement, return to Add search conditions to an SQL statement (WHERE or HAVING clause).

To add a pattern match (LIKE) predicate to an SQL statement:

  1. In the Operator list, specify the type of pattern match you want to perform:
  2. In the Pattern field, type a string. Wildcard characters (%, _) can be used.
  3. Optional: Below the Pattern field, select an option for the type of match that you want to find.

Return to Add search conditions to an SQL statement (WHERE or HAVING clause)