[V4MD] Equivalent of V12's WordStarts operator?

[Ruslan Zasukhin]

On 9/27/08 12:15 AM, "Irv Kalb" <Irv at furrypants.com> wrote:

> I'm close, but it's not fully working.
> 
> I have a sample table with only one long field called
> AuthorYearRefKeywords.  I create a table from this data, and I tried
> marking the field as 'string', and also tried it as 'varchar' - I
> marked the field with the flag:  [#fIndexByWords].

> If I look at the resulting table using Valentina Studio, and the one
> field in this table has a maximum size, a colon, and the letter W
> after it.   I assume that this tell me that is it is indexed by words.

Must be yet flag I  -- fIndexed

Right now you only have inform engine that you want IndexByWords,
But have not create index itself yet

 
> In my application, I am taking user input, which may be multiple
> words, and building a query string to find matching records.  If the
> user types in:  Hays,  the query string I build is:
> 
> "SELECT AuthorYearRefKeywords FROM Biblio WHERE
> (left(AuthorYearRefKeywords,4) = 'Hays')"
> 
> It successfully finds five records that start with the word 'Hayes', like
> this:
> 
>        Hays, Kelley Ann, E. Charles Adams and Richard C. Lange, 1991,
> Regional Prehistory  ...
> 
> However, it does NOT find any records where the word 'Hays' is
> embedded in a record, like this:
> 
>        Adams, E. Charles and Kelley Ann Hays, (editors), 1991,\i
> Homol'ovi II: Archaeology ...
> 
> 
> I tried the "LIKE" syntax, but it did not get any matches all.
> 
> I'm hoping that it's something simple.

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