Filter %artist% NOT "The"

%artist% NOT "The"

want to filter all artist tracks that does NOT contain The
thought this would work but doesn't

Nor does

%artist% MISSING "The"

help please

Try
NOT %artist% HAS " the "
which looks for the article.
Otherwise you might also find "theology" or "Thelonious Monk"

It's strange that NOT comes first would never have thought of it that way around thanks

Sometimes the documentation might shed some light on such mysteries:

Logical expressions don't follow traditional conversational grammar. Operators like AND, OR come between test conditions to combine teach of the results. The NOT case has to come before the test expression to indicate the true/false result is to be inverted.

Thank you for the explanation
:+1::+1::+1: