>>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

Very good point!