virtuals fields / ViSQL

[jda]

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

OK, that's what I thought (but was confused a bit by your previous 
statement -- I told you I didn't understand too well). Thanks for 
clearing that up.

Jon