Hi All, Does anyone know a way to truncate a table as you would in SQL Server using the TRUNCATE command? I have a table where I have to reset the autoincrement number so that it starts with one after deleting all the rows. Thanks, Dave /** David Mitchell dave at dbmdata.com www.dbmdata.com */ MortgagePro.ca Now accepting online applications! http://www.mortgagepro.ca