Using Delete Query

  • Thread starter Thread starter Guest
  • Start date Start date
How can I use a delte query to delete all records that begin with a certain
letter?
Click to expand...

yes. Backup your database before you even think of testing this.

DELETE *
FROM yourTable
WHERE [FieldName] LIKE "'" & [Enter a Letter] & "*'"

Cheers,
Jason Lepack
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting Rows In a Database 1
Delete Query: Could not delete from specified tables 0
delete query 1
if else with insert update 8
can not rerun Make table query - say has to delete prev. 5
Delete Query using linked table 1
Deleting Empty(Null) Records 2
query field names changing to expr#: 8

Back
Top