View Full Version : Queries


Shukri
05-11-2002, 01:17 PM
How do I create a query deleting all files that begin with a specific lrtter?

raskew
05-11-2002, 04:01 PM
When you say "...all files", do you really mean "...all records"?

raskew
05-11-2002, 04:20 PM
Assuming that your intention is to delete records, not files, here're a couple of
examples that you can try in Northwind:

This one returns all Employees whose last name begins with "D":

SELECT Employees.*, Employees.LastName
FROM Employees
WHERE (((Employees.LastName) Like "D*"));

You could then turn this into a Delete query (don't actually run it) with this:

DELETE Employees.*, Employees.LastName
FROM Employees
WHERE (((Employees.LastName) Like "D*"));