case-insensitive searches

[Ruslan Zasukhin]

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


-- 
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]