STEM was not a hint on a command to use, but is just the term for the filename part before the file extension. This was just description. To search for A as end of the stem name, you can search for "A.DBF" just like tblekens solution only searches for "A":
Just as Griff said. That's all. Just a more precise observation of what you might need as tblekens solution will remove any records with 'A's in filenames, eg both ABC123.DBF and ABC123A.DBF are deleted from the data, not only ABC123A.DBF. Your data only contains filenames with digits and some As, but I never trust just seeing some samples. You should know, whether that plays a role, but you might not have thought and looked so far into it. By the way such file names are allowed, but once you open up 1234.DBF you don't get alias name 1234, names can't begin with a digit, so that's bad file name choices.
If you want to know where that term for the part before the file extension comes from, look at JUSTSTEM() - which you find, when you use the search feature of the help. It's only related in terminology, has nothing to do with any sql or xbase table command you need. Though it can be used, as in DELETE FOR UPPER(RIGHT(JUSTSTEM(mydbf),1))="A", which would be a very precise way of removing records of dbf fies ending in A before the file extension, no matter what extension, if there is an extension at all. Even when you would store 100174A without the .DBF extension, UPPER(RIGHT(JUSTSTEM("100174A "),1))="A" is true, so in that regard it acts like a RTRIM, too, besides cutting to the first "." in a string.
Bye, Olaf.