Is there a way to check if a column does not contain a list of string? My goal is to figure out if there are any other type of patterns of string beside apple, banana, or orange in the filenm column.

This doesn’t work because it will still show columns that either have apple, orange or banana… the logic is flawed.

    SELECT * FROM dbo.File fWHERE (CHARINDEX('apple', f.FileNm ) = 0
    OR (CHARINDEX('orange', f.FileNm ) = 0
    OR (CHARINDEX('banana', f.FileNm ) = 0)