>I need to search thru specific fields using wild-cards or regular expressions. For example, I need to have a query like: find all records where has "12345" ignoring any leading alphabetic characters. Though we all probably know how to do that, VFP won't do that very quickly. > >Can anyone recommend a fast text search engine that can handle DBFs and memos and can also do that quickly? > >Thanks.
Have you tried the $ operator or any of the AT() functions?