I'd like to pull some data where status is equal to "T" for terminated and not in a list where there might also be one type of active coverage for the same insured person where status="A". There are different types of insurance coverages.

I don't see how I can do a WHERE NOT IN, although there is NOT INLIST(), but that doesn't seem to fit.

Any ideas?

Cecil