>Does anyone know of a FAST way to search a memo field for a string. (say look for the string "System testing problem" in a memo field for all records in a DBF)

You know, I don't get too bad performance out of code like this:

LOCAL lcSearchString, lcTableName

lcTableName = [your table]
lcSearchString = "system testing problem"

SELECT(lcTableName)
SCAN FOR lcSearchString$LOWER(lcTableName.Memo1)