[V4MD] method field

[Richard Altenburg]

On 20-04-2003 10:07, "Henning Pertiet" <valentina at pertiet.de> wrote:

>>> What I didn't notice is that - for example - a word at the end of a
>>> long text would not be found.
> 
>> And this is obvious.
> 
>> You have forget to add SPACE between fields in your CONCAT:
>> More correct is:
> 
>>             CONCAT(bearb,' ', titel, ' ', text)
> 
> 
> What exactly is the difference here?

When you concatenate some fields without the spaces, Valentina treats them
as one word. With spaces in between, the index for the field contains every
single word, and so you will have more success finding them.