>>Hi,
>>
>>SQL can not do this, because SQL does not depend on the order records are stored.
>>In general even for dbx the order of records should mean nothing. This simply bad design
>
>True, but here I guess in this case it just is the line order of a txt/PS document fed into a vfp table, so the recnos achieved could be seem as a stream quality/representation ;-)

But then there we have better commands to do it directly on the string / file. I had this idea too, but he asks for table. :)

Anyway, I go with Rich's version. Better then mine. :)

>Via SQL the corresponding begin/end records can be found and ranges "in between" be deleted via single xBase or SQL command.
>Could be faster - either via begin/end plus recno() put into 2 arrays or into a cursor to build a single delete command...

How do you adress a range between records with SQL? RECNO() is not reliable. There are things that work with VFP, I agree, but I would never use this. The next code monkey tries to do gather the VFP code and use it on some SQL server ...
Basically it's against anything SQL was made for.