Oracle 10g supports regular expressions much like RLIKE for mysql. The syntax is a bit different tho.
SELECT testcol FROM test WHERE REGEXP_LIKE(testcol, '^..a.'); (from http://www.psoug.org/reference/regexp.html) Could the QueryBuilder be changed so that if a Oracle driver is being used the above syntax is generated for the 'rlike' operation? Thanks, Kevin ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object