Ms access query a memo field

Databases
1

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?

Thank you.

2

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