How can I use a delte query to delete all records that begin with a certain letter?
S SpIkE Mar 9, 2007 #1 How can I use a delte query to delete all records that begin with a certain letter?
J Jason Lepack Mar 9, 2007 #2 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
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
