> myfield like "%FORD%" ;
> and not myfield like "%_FORD%" ;
> and not myfield like "%FORD_%"
>
>will allow FORD in any way except as a part of a word (no characters
>before it, and no characters after).
>
>It works (tested). Should be better optimizable than checking for left
>and right edges of the field.

Thanks, Dragan --
Someone said there are 3 ways to do everything in FP; I guess we now have three. I since have discovered that just leaving off the '%' on the left and right works also:

   where myfield like '%FORD ';
    or myfield like '% FORD %';
    or myfield like ' FORD%'