Filter
Top Products
[Figure: Using the LIKE predicate to specify rows]
Use a character string, arbitrary string specifier, or arbitrary character specifier to represent the pattern. Table:
Arbitrary string specifier and arbitrary character specifier explains the arbitrary string specifier and the arbitrary
character specifier. When the pattern is a character string, use alphabetic characters to specify the pattern. When the
pattern is in a national language, use national-language characters to specify the pattern.
[Table: Arbitrary string specifier and arbitrary character specifier]
Examples of using arbitrary string specifier %
Examples of using arbitrary string specifier% are shown below. "Figure: Example of LIKE predicate specification
(using an arbitrary string specifier)" shows which row is specified. Schema SCM contains the table TBL5 used in these
examples. SCM.
Example 1:
101