I'm about to modify my TextSearch function to be compatible with Tim's latest CONTAINS function but working on non indexed columns.

I feel reasonably happy with how CONTAINS, CONTAINS ANY, DOES NOT CONTAIN will work but my brain surrenders at DOES NOT CONTAIN ANY.

It may be that Tim has simply carried out a CONTAINS ANY test and flipped the result, and I could do the same but it just doesn't make sense to me.

Can anyone provide an explanation that will penetrate the fog?

Roy Lambert

I think I've got it - with a bit of rewriting


DOES NOT CONTAIN ANY
Returns True if the left column reference contains none of the word values specified in the right string expression. It is the inverse of the CONTAINS ANY operator.

There is now only the question of on which of the tests, and where on each word can * be used.

Roy Lambert