>I'm selecting two records in a table so I can copy or delete all the records between each of the selected record. My problem comes when the table is indexed. Is there a way to do this? I'm having a problem determining if the second record is before or after the first record. I'm using 5.0a. TIA

lcKey = key()
* On one of recs
luValue1 = eval(lcKey)
go nOtherRec
luValue2 = eval(lcKey)
select * from mytabel ;
  where &lcKey between ;
  min(luValue1,luValue2) ;
  and  max(luValue1,luValue2)

Cetin