Using an Escaped LIKE Clause

From: Andrew Lindesay (ap..indesay.co.nz)
Date: Wed Jan 27 2010 - 20:41:46 EST

  • Next message: Lachlan Deck: "Re: Using an Escaped LIKE Clause"

    Hello;

    A question about escaping a LIKE qualifier;

            ExpressionFactory.likeExp(...,...)

    JDBC specifies the ability to use '%' and '_' as matchers for characters and a character respectively. It is then possible to escape use of those characters as in the following example;

            SELECT a FROM tabA WHERE a LIKE '%=_' {escape '='}

    I can't easily see a means by which one can specify the "escape" clause in a SelectQuery -- can anybody shed some light on this for me.

    Regards;

    ___
    Andrew Lindesay
    www.lindesay.co.nz

    This archive was generated by hypermail 2.0.0 : Wed Jan 27 2010 - 20:42:24 EST