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

Figure 2-26 shows a data search example using a LIKE predicate. Here, form numbers, product codes, and the ordered quantities are searched from the order table for those customer codes whose second character is T.

Figure 2-26 Data search example using a LIKE predicate