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