Query criteria

[Tut]

Hello, I am trying to find the following in a field, the name "kennel"
I have several thousand records that contain the word kennel in the business
title:
Business Name:

Happy tails kennels.
Johns kennels and boarding.
Kennels and boarding by Mary.
Kennedy's dogs.
Bobs kennel and boarding.

How, in the criteria can I select only the word "Kennel or Kennels" for this
field?

Thanks in advance.
Bob

 

[Paul Ridings]

WHERE BusinessTitle LIKE '*Kennel*'

Hope that helps

 

[Tut]

Thanks, what worked, was *kenn* in the criteria.
This turned on the LIKE "*kenn*" statement which worked perfectly.
Thanks for your help.
Bob