If you want 10 records deleted... DELETE FROM tablename a WHERE a.ID IN ( SELECT TOP 10 b.ID FROM tablename b WHERE ... [criteria] )
>>> "Frank Mamone" <[EMAIL PROTECTED]> 04/01/02 09:35AM >>> Hi, I want to delete a specific amount of records matching a criteria. I may have many records matching the crteria but I want to delete a specified amount. Is it possible to do this directly with SQL? Thank you, Frank Mamone ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists