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?