This section describes using LIKE transformations as a comparison operator. LIKE transformations Internal transformation of statementsLIKE predicates

LIKE transformations and optimizations are disabled when you use locale-based collation. See "Character-based collation in " in the for information about locale-based collation.