A CONTAINING predicate tests whether or not the string expression
specified in the second value expression is contained within the
string expression specified by the first.
(B)0[m[1mcontaining-predicate = [m
[1m [m
[1mqqq> value-expr qwqqqqqqqwq> [1;4mCONTAINING[m[1m qq> value-expr qq> [m
[1m m> [1;4mNOT[m[1m qj [m
[1m [m
The CONTAINING predicate is not case sensitive.
The CONTAINING predicate is sensitive to diacritical markings
used in any Multinational Character Set. Therefore, a matches a,
but neither matches á, à, ä, Á, À, Â and so on.
In Spanish, ch and ll are treated as if they were unique single
characters.
If you use a collating sequence, the CONTAINING predicate
will not be sensitive to diacritical markings used in any
Multinational Character Set.