like operator in access query

[mit]

Hi,
I have a field in my table called category,I want to find the data in this field which has this string "dentist" in it.where ever it is(left,write,middle of the text),I should search it by a query to find records with this string.



I can use like operator,for example like dentist*
but it gives me the data which has the dentist word at the beginning of the word not all data which has "dentist" in them.

[Bob Fitz]

I think you need to use Like *dentist*

[mit]

but this one gives me dentist which is in the middle of string.am I right?

[Bob Fitz]

It should return all records in which "dentist" exists. At the Start, In the Middle or At the End.
Please try it and post back with your findings!