First off, thank you all so much for the help you provide.
I'd like to write a query were I exclude a row any time a project number starts with 9CT with the except of the one instance where it says 9CTAT
So lets say we have data like this:
7CTmisc
9CT01
9CTRJJ
9CT45
9CTmisc
9CTAT
10CT11
I...