Loose search

[Ralf Sander]

Am 17.04.2005 um 19:23 schrieb 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

as fast as "=" searches?

But LIKE is case sensitive, too. The "no_case" keyword of version 1 
seems not to work anymore.

Many Cheers,
Ralf