>REPLACE ALL memo field name WITH STRTRAN(memo field name, "vendor", "manufacturer")
>
>in a memo filed, it is not that just find a word in a memo filed
>and list all record that contains the word. Question is how
>you do it. If you have suggestion, I appreciate it very much.

I'm not sure how you would do it, but it seems that you should be right... there should be some way to just search for memos containing certain words. What about some variation on :

select * from tablename where certain string $ <some function>(memofieldname)

At least that would be my best guess. :) Sorry I couldn't help.