>>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!
If it's not broken, fix it until it is.
My Blog