Loose search

[Ralf Sander]

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?

Many Cheers,
Ralf