Josh,
That's true that there is more flexibility but the reason I'm asking the question is that in Oracle, for example, individual indexes to nothhiung for speed where as the compound index fld1 + fld2 = x + y has a noticeable sppedup

Are you saying that VFP's engine deals with both ways the same??

Sandy