cfif question using NOT IN ?

I have a routine that checks the validity of some items in a transaction against some values in a database.  I need to add a new variable to check against.    I want to check the transaction rows that are selected to see if any match the value IMITEM.Webaccessibility with having the value ‘A’ or ‘S’.    In the example below I added the column to the query so it is selected, but what is the best way to check the compared […]