I have an access db with a memo field. I am trying to query this field to return a keyword and not get hits on derivatives.
I am using a simple select statement with a like clause.
select * from body
where like "visit";
But it will not return anything unless I use wildcards and then I get more then I want.
Can someone but me on the right path?
the problem is space is a character
when you use where fieldname like "visit"; it is does not make sense it is equal to where fieldname="visit";
you cab use wildcards on any side of you value or on both sides depence of what you need