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.
Example: Typing j_ searches for a string that is exactly two characters long, with a first character of j.
Example: Typing SYSTEM% searches for the string SYSTEM with any number of characters (or no characters) occurring after the string.
Example: Typing _j% will search for a string of any length, with a second character of j.
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:
Return to Add search conditions to an SQL statement (WHERE or HAVING clause)