>>>>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..
>
We've considered it, but we're stuck (again) with no budget/spending since Congress has not passed our Appropriations bill, and seems in no hurry to do so :~( Maybe in future, especially if app Beta users complain about speed...