A LIKE predicate is transformed into a predicate that uses the = operator
(and a NOT LIKE predicate is transformed into one that uses <>) when
the character string does not contain any wildcards. For example:
becomes
and
becomes
Predicates that use the = operator are