>>I do know what a Truncate command does. That's why I reacted with surprise.
>
>I think Nick was talking about the real table he wanted to clean up. If the table is big, then the usual advice is to select only rows we want to keep, truncate the table (zap in VFP) and put that saved rows back into original table. Of course, the process needs to be put in transaction.

That is the quickest, however if there is Referential Integrity involved its a different ballgame.