I have a table called Lists with a column called Name. It’ has 3 rows containing are AAA, BBB, CCC in the Name column.
I have another table called Items. It has a column called List which is a select column based on the Lists table. It has 2 rows containing AAA, DDD and in the List column.
I created a view called Bad Data.
If I filter Bad Data on NOT(Contains(Lists.Name,List)), I get the expected results. It show only the row containing DDD which is what I want.
If I filter Bad Data on NOT(In(Lists.Name,List)), it shows ALL the data.
So, what’s the difference between Contains and In?
Thanks … Jeff