Best Way

[Michael de Haan]

Ruslan.
Now that I think of it, I am not sure if I conveyed what I really want;

for example...lets say I am looking for "The big bad wolf"


Now,
  I would like this to be found with "The big bad wolf" or "The bad big 
wolf" or "bad wolf big the" etc etc.


Does this change your answer

Michael.


On Jan 11, 2004, at 1:40 PM, Ruslan Zasukhin wrote:

> on 1/11/04 11:31 PM, Michael de Haan at mdeh at earthlink.net wrote:
>
> Hi Michael,
>
>> 2 questions:
>>
>>
>> (1) What is the best way to search for , for example
>>
>> ‘word1’ ‘word2’ ‘word3’
>>
>>
>> where word1, word2 or word3 can be in any order.  In the past, I have
>> used the "LIKE" and " AND"  operator to put each word into it's own
>> LIKE statement, but I wondered if there is an easier "Valentina" way?
>
> I think you can try combine 3 words in the SIGNLE like using REGEX's
> OR statement.
>
>     fld LIKE 'word1|word2|word3'
>
> Then search will be ONE scan of file, i.e. 3 times faster.
>
>
>> (2) If the user is allowed to use double quotation marks " " to 
>> defined
>> an exact search, does Val provide a way to recognize this or must it 
>> be
>> appropriately parsed by the program before being passed to the Val
>> engine?
>
> You need parse it.
>
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>