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

if you doesn't go to the mountain,
then you make to walk the mountain:

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