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