>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
>
Everything is possible. Having words to exclude in additional table, have a LEFT JOIN with them on LIKE condition and check for WordsToExclude.ID IS NULL condition.
I may expand my blog later including this twist.
If it's not broken, fix it until it is.
My Blog