>Hi,
>
>>The fastest ?
>
>You need to test that. I'd bet on COUNT, because it doesn't procedure any large output and - unlike SCAN - is a single command handled internally by VFP.


Tested
It is scan ... endscan

Count with noptimise takes quite a time (w/o optimise the table is not completely loaded in memory)
even Calculate takes time

So I will have to stick to scan..endscan for now