Delete query with wild cards

[elentz]

I have a table with about 15000 entries. there are many of them that I want to delete. I need to be able to delete certain part numbers. All the part numbers would be in this format xxx.xxxx.1 Most of the other part numbers are in this format xxx.xxxx So I want to delete ALL the entries with the .1 suffix. How can I show that in a delete query??

Thanks

 

[r937]

delete from smorgasbord where right(entree,2) = '.1'

r937.com | rudy.ca

 

[elentz]

So simple I am embarassed!

Thank you!

 

[MacTommy]

Or try:

[tt]DELETE FROM smorgasbord WHERE entree LIKE '%.1'[/tt]

(or better, first try [tt]SELECT * FROM smorgasbord WHERE entree LIKE '%.1'[/tt] )