Loose search

[Ruslan Zasukhin]

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

Hi Ralf,

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

:-) almost


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

IF you have assign for db/table/field

    collationAttribute( kStrength ) = kPrimary

Then this field have case-insensitive index, searches and sorting.
LIKE also take into account this parameter.



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