I appreciate all the input. With all the suggestions I believe I have finally gotten this the way sales will like it.
I used the combination of Rkey, indexes and the Like optimization with the variable radio button to get the speed desired. Thanks again for the help. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Friday, February 12, 2010 1:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: ON KEY PRESS << That being said it looks like I could use something like %LIKE% to accomplish the same. >> This will follow the same optimization rules as CONTAINS. If you have a wildcard at the beginning of the matching term then the search cannot be optimized. LIKE can be optimized if the wildcard occurs elsewhere in the matching string. -- Larry
