> 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%'
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.