I've received an Access database with a SUBNATIONS field that can contain Mexican states, American states or Canadian provinces that are comma-delimited. An example might be "AZ, CO, MEXCH, BC." I'm interesting only in rows with at least one American state (drop if only found in Mexico or Canada).
I've tried the IN operator [In ("AL", "AZ", ... , "WY")] but that only reports rows with one state occurrence (not multiple states occurrences as above). I've looked at other operators but nothing seems to be working.
I'm new to Access and SQL and am wondering if: (a) I can perform this with a simple query, or (B) if there are more sophisticated searches I need to perform that I'm not aware of?
Thanks,
Mike