virtuals fields / ViSQL

[Ruslan Zasukhin]

On 1/14/05 7:13 PM, "jda" <jda at his.com> wrote:

>>> Valentina 2.0 now can do searches on NON-indexed fields.
>>> So to really build index, you need explicitly say: fIndexed.
>>> 
> 
> I've been looking at the SQL docs but don't see an obvious answer to
> this question: what is the SQL way to search an *unindexed* text
> field for a
> 
> 1. word begining with "aaa"

But no way Jon!

You need to have index BY WORDS to be search WORD START WITH.

Otherwise you will search LINE START WITH


> and a
> 
> 2. word "aaa"
> 
> without using REGEX?

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