For example,
becomes
The first (LIKE) predicate is not optimizable, but the new predicates added by the transformation are.
When the character string begins with one more character constants and ends with a single "%", the first LIKE clause is eliminated. For example,
becomes