>Is there a good way to search a character field for
>the occurance of a string?
It may actually sometimes be faster with large tables to use SQL to pull off the PK and the given search field into a smaller local cursor, search it using '$' into another cursor, and then pull off the table records using a JOIN on the second cursor's PKs.
Might be worth a test, anyway.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
