>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.
While ASCAN() works in queries, it's risky if you're working with character data. ASCAN() is controlled by SET EXACT, while queries are controlled by SET ANSI.
Tamar