Text columns

[jda]

>RecID    TEXT with Index by words.
>--------------------------------------
>1       "008.45"
>
>
>        
>Valentina for THIS record add into index 2 entries:
>
>         008     1 
>         45      1
>
>
>So when you do search
>     WHERE fldText = '45'
>
>
>You find in index second entry, and therefore record 1 is selected.
>
>
>How Valentina break string on words:
>     again it try do this naturally
>     spaces, punctuations -- all these are breakers.
>
>


The indexing algorithm could be a bit smarter, though, no? For 
example, if a punctuation mark is not followed by a space it should 
be considered as part of the "word". This would be helpful for some 
names: for instance, O'Shea.

Jon