case-insensitive searches

[Ruslan Zasukhin]

On 7/2/05 1:24 AM, "Charles Yeomans" <yeomans at desuetude.com> wrote:

>> Well,
>> 
>> It looks that you expect that IF field is indexed by words, than
>> 
>>     SELECT textField from ATable WHERE Lower(textField)="foo"
>> 
>> Will find you record with "foo too roo doo" ?
>> 
>> NO.
>> 
>>     Because Lower(textField)='foo'     // by the way, single quotes
>>     will not do indexed search.
>>     it will do simple SCAN of column.
>> 
>>     and it can find only record with "foo", "FOO", "fOO" values
> 
> I expect that Valentina can do anything :)
> But for now I will use method fields as I have been.

And more:

With methods it works because OTHER mechanism is used.

    Method => has own index with low case words

    later you do direct search on this index

        WHERE methodFF = 'foo'


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]