RE: [GENERAL] non-case sensitive searches

1999-01-14 Thread 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 > ^)

RE: [GENERAL] non-case sensitive searches

1999-01-14 Thread Gregory Maxwell
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 btr