You can select rows that contain a string of characters that are part of a word or number that you know exists in the data. In the following query, LIKE %NY in the ADDRESS column means "where the address ends with NY, with anything at all before that." The percent sign (%) stands for "anything at all" (any number of preceding characters or none).
When you run this query:
Q.APPLICANT | NAME | ADDRESS | ------------+------+----------| P. | AO. | LIKE %NY | |
QMF produces this report:
NAME ADDRESS --------- ----------------- JACOBS POUGHKEEPSIE, NY LEEDS EAST FISHKILL, NY REID ENDICOTT, NY