How do I select records were a field contains a key word??

[OldManEd]

I have a field named [Comments], a text field. I want to create a query that
selects records that contain the word "Not" somewhere (anywhere) in the
field. Is this possible?

OldEd

 

[Rick Brandt]

I have a field named [Comments], a text field. I want to create a
query that selects records that contain the word "Not" somewhere
(anywhere) in the field. Is this possible?

OldEd

....
WHERE Comments Like "* not *"

 

[OldManEd]

Thanks, that worked. I was missing the "*"s
Ed.

I have a field named [Comments], a text field. I want to create a
query that selects records that contain the word "Not" somewhere
(anywhere) in the field. Is this possible?

OldEd

...
WHERE Comments Like "* not *"