case-insensitive searches

[Charles Yeomans]

On Jul 1, 2005, at 2:51 PM, Ruslan Zasukhin wrote:

> On 7/1/05 7:09 PM, "Charles Yeomans" <yeomans at desuetude.com> wrote:
>
>>
>> On Jun 29, 2005, at 3:36 AM, Ruslan Zasukhin wrote:
>>
>>> On 6/29/05 1:52 AM, "Charles Yeomans" <yeomans at desuetude.com> wrote:
>>>
>>> Hi Charles,
>>>
>>>> I've got a text field that is indexed by words.  In V4Rb 1, to do a
>>>> case-insensitive search I needed to define a method field and search
>>>> it.  Is this still the case in V4Rb 2, or can I now do something 
>>>> like
>>>>
>>>> SELECT textField from ATable WHERE Lower(textField)="foo" ?
>>>
>>> This should work in 2.0.
>>
>> It turns out that it doesn't work.  Here, textField is a VarChar field
>> that is indexed by words.  I tried making queries with VStudio as 
>> well.
>>   Other SQL string functions work; for instance,
>>
>> SELECT textField from ATable WHERE Left(textField, 3)='foo'
>>
>> works.  But other functions do not --
>>
>> SELECT textField from ATable WHERE Reverse(textField)='oof'
>
> Ivan.
>
> Please check this RIGHT NOW
>
> in vstudio make small test db

I just made a small test db using VStudio, and queries of the type 
above didn't work.

--------------
Charles Yeomans