>>>>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.
Matt McDonnell
...building a better mousetrap with moldy cheese...