* This might help >* If you set it to a large number and there are fewer you just get the fewer rows >* e.g. if you set TOP 100 and there are only 20 rows, you get 20 rows: >SELECT TOP nnnn ; > ...I thought about using TOP nnn but my understanding (and maybe I am wrong) of how VFP selects them is by preselecting ALL records meeting WHERE and then selecting the nnn of those. Therefore, I was concerned that TOP will slow down the SQL Select considerably. I know I should test it before making assumptions.