<< So CONTAINS always seemed to give me the results I wanted without having to play around with wildcards. >>
If you need to do a CONTAINS search (because you really need to search the whole field, not just the start of the field), then there's no way to avoid it. Unfortunately, that kind of search is not optimizable without implementing some kind of full-text indexing. If you're going to do a CONTAINS search it makes sense to try to include some other optimizable criteria in the same search to limit the number of rows over which R:Base has to perform the CONTAINS. Alternatively, you can implement a LIKE 'String%' which will be quicker and then include a "Find More Matches" button underneath the results to perform the CONTAINS search. That will be slower, but the user will understand that they're asking for an extra-special search. -- Larry
