Need help with a search function

Hi, what I'm trying to do is find an instance of a word(s) that is submited via a search box. I need to search a field and if that word appears in the field, (say a Summary field), pull back all the data that goes with that record set. I've done this using like(%searchword%), using the word age as the search word and it will pull back any thing with age in it, such as rage. I've tried using the like('searchword'), but that would not pull anything back, even when I know there is age in one of the summary fields.

code sample: strSQLTest = "Select * from tbApplicants where Removed='" & 0 & "' AND ("
do while Not intCounter > intArraysize
strSQLApplicant = strSQLApplicant & "SummaryLike '%"&arrKeywords(intCounter)&"%'"

I was wondering if there is anything like InStr that might work, or a better way of going about this.

Any help on this would be greatly appreciated.