Loose search

[Ruslan Zasukhin]

On 4/17/05 8:06 PM, "Ralf Sander" <ralf at end-if.de> wrote:

> Hi Ruslan,
> 
>> 
>>> Hi Ruslan,
>>> 
>>> Yes, but you wrote, there is a possibility (and an example) for SQL,
>>> too.
>> 
>> Example -- not remember,
>> Aha,    I see analog of IndexByWords exists!
>> 
>> Yes, in SQL exists analog based on standard functions.
>> Important is that for THIS functions Valentina recognize and can use
>> indexes.
>> 
>>     left()
>>     right()
>>     locate()
>> 
> 
> But as left and right are case insensitive, locate is case sensitive.
> Are there any possibilities to search for the part of a word case
> insensitive?

    WHERE fld LIKE '%str%'

Starting from 2.0.3fc1  LIKE even can do INDEX SCAN, so this is very fast


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