>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.

Kenneth,

I haven't tried this with a memo field (yet), but here's an idea that works with normal character fields.

oRE = CREATEOBJECT('VBScript.RegExp')
oRE.Pattern = "(\w+)(\d+)"
SELECT *;
  FROM MyTable;
  WHERE oRE.Test(MyTable.MyMemoFld);
  INTO CURSOR Foo

George

Ubi caritas et amor, deus ibi est