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

Bruce,
If you need to do alot of this, why not also try loking at Phd.. A package that allows you to di indexing/searching on strings in dbf's..

Thanx!

Tony Miller
Vancouver, Wa