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