The LIKE predicate manipulates rows that have a specified character pattern in their column.

The following figure shows, as an example of a data search using a LIKE predicate, the procedure for searching the order table for the form numbers, product codes, and quantities ordered for those customer codes with T as the second character.

Figure 2-26 Data search example using a LIKE predicate