I want to create a query that identifies entries where a long text string does not contain any of a list of substrings.
What I have is...
SELECT [other necessary data], [Long text string]
WHERE [Long String] NOT LIKE "*[substring1]*"
AND [Long string] NOT LIKE "*[substring2]*"
AND [Long string] NOT LIKE "*[substring3]*"
This works fine. HOWEVER! I want the list of excluded substrings to be variable, e.g. project 1 excludes substrings 1 and 3, project 2 excludes substrings 2, 3, and 17, etc.
Any suggestions on how to go about doing this?