Update: Solved. Thanks all
This shouldn’t be complicated but for some reason…
I am trying to search all open data bases for certain file types so that I can remove unsupported file types.
Example: Looking for Apple Pages documents. I search for the string *.pages and all it returns are documents where the word “pages” appears in the name of the document (exclusive of/ignoring the extension) or in the document itself. (By “exclusive of/ignoring the extension” I mean that it doesn’t even find the docs with the extension even tho that is part of the file name. So a search for *.pages does NOT find a document called Book_Report.pages, but it does find doc called Book_Report_Pages.pdf. Same with .numbers or .rtfd, xml, .webarchive, etc.
I found a post where the tool Edit>Find>In Database was suggested. That doesn’t do anything at all.