>I have a customer that would like for me to search memo field for specific words and update another table based on the results. For example if I search for "Ford" they only want to update for items that contain "Ford" and not things such as Bradford, Kingsford and so on. What's the best way for me to do this?

SELECT * FROM YourTable;
       WHERE MyMemoField LIKE '% Ford %';  && Note the spaces around Ford
       INTO CURSOR cTest

or

SCAN FOR [ Ford ] $ MyMemoField
ENDSCAN

** Update: Both ways will work only if the memo not begins or ends with Ford.