RE: [GENERAL] non-case sensitive searches

[Jackson, DeJuan]

> On Wed, 13 Jan 1999, Jackson, DeJuan wrote:
> 
> > And remember unless you use full text indexing (which is 
> expensive) you
> > won't have indexing on that search (for either the LIKE or regex).
> >     -DEJ
> 
> Actually, if you use case sensitive regex, and anchor the 
> begining (with
> ^) then it will use btree indexes.

So will a front anchored LIKE, but the query that was being performed
was an unanchored LIKE (i.e. '%stuff%').