>>>>I'm trying to do an SQL that searches for whole words only, using the '%'...
>>>>myfield LIKE "% FORD%" OR
>>>>myfield LIKE "% FORD %" OR
>>>>myfield LIKE "%FORD "...which correctly gets
>>>>
>>>>FORD MOTORS
>>>>DIXON FORD
>>>>BIG FORD CO
>>>>
>>>>but also BUFORD TIRES and CITY OF FORDHAM, which I don't want.
>>>>
>>>>Any ideas on how to do this? Or a better technique?
>>>
>>>LEFT(myfield,4) = "FORD" OR ;
>>>RIGHT(myfield,4) = "FORD" OR ;
>>>" FORD "$myfield
>>
>>Thanks...that's what I needed, a fresh perspective.
>
>Actually, I think you'll have to have
>

>LEFT(myfield,5) = "FORD " OR ;
>RIGHT(myfield,5) = " FORD" OR ;
>" FORD "$myfield
>

>or you'll include Fordham City and City of Buford.
>
>Barbara

I was thinking about that on the way to work this morning, but thanks Barbara, you beat me to it.