>I have a table with 40,000+ records in it. On my form I type in a number which cooresponds to a drawing number field in my table. I use "Scan For Like(maindatatable.dmdrno, This.Value)". This doesn't take too long on my 450mhZ CPU machine but on slower machines (100mhZ CPU) it takes several seconds. What can I do to improve this. Thanks for your help.
>
Buy all the other users 700MHz PIII systems with lots of memory...
The LIKE() function is never optimizable - reconstruct the filter condition on the SCAN to use an Optimizable expression.