[RDBO] REGEXP_LIKE for Oracle 10g

2007-12-28 Thread Kevin McGrath
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 a

[RDBO] REGEXP_LIKE for Oracle 10g

2007-12-28 Thread Kevin McGrath
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 ab