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

Here something that should works all the way (I think)

SELECT * FROM YourTable;
       WHERE MyMemoField LIKE '% Ford %' OR;  && Note the spaces around Ford
             MyMemoField LIKE 'Ford %'   OR;  && Memo begins with Ford
             MyMemoField LIKE '% Ford';       && Memo ends with Ford
INTO CURSOR cTest

but the speed will be deadly :o)