Best Way

[Michael de Haan]

thanks Ruslan
I will give it a try
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
>