>cool! the secret seems to be the 'like%' in the join. I have never used that
>Now, one more kink!
>how about all sons and fathers but not mothers
>
>:-)
>
>possible?
>
>Peter
>

I added ability to exclude certain words.

See the bottom of this blog

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/how-to-search-for-all-words-inclusive-wi

also as you can see, the different solution (Niikola's) is much faster than the one we came up with Boris. Try it instead.