Hi,

We will fix up the lower case issue.

The substring is like that by design. Substring only does right substring matches, so gram matches gram*. This is because it uses an SQL index to look up it's results, and you can't use an index if your query is '%gram%', only 'gram%'.

As mentioned in email, the regular search won't work as Oracle can not do '%term%' on text (clob) fields. I'd be happy to work with you to create an interface to use Oracle's full text indexing if you are familiar with it.

Cheers,

Alex
--
Gossamer Threads Inc.