[V4MD] Index by Words (newbie question)

[Daniel Crowder]

Thanks!

If I wanted to search a complete word and not a partial word is there a 
more streamlined way of doing that?

On Oct 3, 2004, at 5:53 PM, Ruslan Zasukhin wrote:

> On 10/4/04 12:48 AM, "Daniel Crowder" <daniel at monumental-i.com> wrote:
>
> Hi Daniel,
>
>> I'm looking for ways to speed-up a product search.
>>
>> I currently am using LIKE to check to see if certain key-words exist 
>> in
>> a field called TEXT. Reading over the documentation it says that using
>> LIKE in a query does not take advantage of a field's index. I am now
>> confused as to how to take advantage of the INDEX BY WORDS feature. 
>> How
>> do I perform the fastest query of a text field that is using INDEX BY
>> WORDS without using LIKE?
>
> You should do query of kind
>
>     WHERE left( textFld, 3 ) = 'abc'
>
> This will use index
>
>
> -- 
> 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
>
>
_______________________________
Daniel Crowder
Partner

Monumental
Natural Interactive Solutions

828 Ralph McGill Blvd. W-2
Atlanta, GA 30306

AIM: danielmonumental
Phone: 404.223.0303
Fax: 404.223.0309
monumental-i.com