I am running a query that gives me a listing of various e-mail addresses tied to a specific project. I need to filter out all the ".com" addresses. If I run the original query and then do an "ends with" filter on the results it gives me the correct listing. If I put a "like" condition into the original query, it only returns a small subset of the listing (28 returns as compared to the 575 it should output). The field that stores the e-mail address is a hyperlink field if that makes a difference.
Is there another way to automate the "ends with" text filter into a query?
Is there another way to automate the "ends with" text filter into a query?