>What is the fastest way to search through a file to find a substring within a field? I know you can
>
>set filter to 'xyz" $ yourfield
>go top
>
>or an SQL Select equivalent, but in a file where there are thousands of records, it takes a long time, specially on a network...
>
>Is there a quicker way?
>
>Many thanks!
Hi John
You can use LOCATE instead of GO TOP. That may give you a small boost. The best thing of all will be to use SQL to build a cursor. It will be faster to navigate the resulting cursor than moving through your completely non-rushmore-optimizable set filter. By that I mean yes, there are ways to rushmore optimize a filter, but not using $.