>for tables without any memo fields:
>Was wondering if anyone knew at what precentage point deleted records casue a significant performance hit when doing SQL statements.
>Is it a basic standard or does it depend on the number of fields and/or type of fields.

AFAIK it depends on a lot of factors. If you use VFP9, you can use the new binary index type which is much smaller in size, and which makes the discussion more or less a non issue. But as a general rule, you should only pack a table in a maintainance module which is run regularly, like once per month or once per year.

Personally I never delete records, so I never need to pack a table. In all my tables I have an extra field, reusable, which is set to true instead of deleting the record. When I need to add a record I do the following

Select top 1 PK from mytable where resuable into array laDummy
if _tally>0 && a reusable record is available
  update mytable set myfield1=myvalue1, myfield2=myvalue2,...., reusable=.F. where PK=laDummy
else
  insert into mytable (myfield1,myfield2,...., PK,reusable) values (mavalue1,myvalue2,....,PKvalue,.T.)
endif