Represents a LHS [ NOT ] [ $ ] LIKE RHS expression.
It should be noted that unlike "normal" SQL the "." character is not supported since in
practice it tends to be redundant.
It is possible to use: $ in front of the "LIKE" to indicate that a case insensitive
comparison should be performed, for example:
SELECT *
FROM java.lang.String
WHERE toString $LIKE '%value'
Also, the LHS or RHS can be built up using the "+" operator to concatenate a string, thus:
SELECT *
FROM java.lang.String
WHREE toString $LIKE '%' + :myValue
In this way (using the
BindVariable named bind variable ) you don't have to provide
the wildcard.
It is also possible to specify your own "wildcard" character in the Query object using:
Query.setWildcardCharacter(char) .
Note: the implementation is a modified version of that provided by: Kevin Stannard
(http://www.jzoo.com/java/wildcardfilter/).
|