Full Text Index Search

[James Milne]

On 25 Oct, 2004, at 21:17, erne wrote:

> Hello James,
>
> why don't you try the IndexByWords option of Valentina for this?
> then you split search field contents in a group of And queries
>
> e.g.
> the search field contains "nice girls"
> the query will be like
> "Where (Left(Comment,4) = 'nice' and Left(Comment,5) = 'girls')"
>
> you can also filter out unrelevant words like "the", "in" etc.

On 25 Oct, 2004, at 21:36, Erik Mueller-Harder wrote:

> Hi, James --
>
> If I'm understanding your need correctly, Valentina already supports 
> exactly what you're looking for.
>
> I have an internal application which archives old e-mail messages, for 
> example.  I've simply defined the message-body field as Indexed set 
> the IndexByWords flag.

Hi Erne & Erik,

Thanks guys. I think I'll investigate the IndexByWords property further.

--
Kind Regards,
James Milne