In my experience VFP arrays are slower than VFP cursors in most cases.

>Yes ASCAN works:
>

SELECT * from sales WHERE ASCAN(Thisform.aSales, Sales.Person,-1,-1,1) <> 0

>
>I was expecting it would be quicker but, as you mentioned, it is quite a bit slower than JOIN.
>
>Thanks for the info.
>
>Regards
>Cyril
>
>
>>I'm not sure what 'static values' means. If they never change, you can make them a part of a query. You can also use ASCAN(). Either one could be slower than storing values in a cursor and JOIN, though.
>>

>>Select * ... Where Sales.Person In ("1         ",  "23        ",   "165       ")
>>...
>>Select * ... Where ASCAN(Thisform.aSales[3], Sales.Person, ...)
>>
>>

>>
>>>