trouble with IIF and Like operator in query

[Liz_I3]

HI
I want to see if 3 word exist in a string field. I have IIf([MemberOF] Like "*dog*","*cat*","pets")I have also tried
IIf([MemberOF] Like "*dog*"and like "*cat*","pets")

Is there a way to find more than 1 string in a text field?

thanks
L

 

[Joe4]

If you want all three:

InStr([MemberOF],"dog") And InStr([MemberOF],"cat") And InStr([MemberOF],"pets")

If you only want to see if any of the three exist:

InStr([MemberOF],"dog") Or InStr([MemberOF],"cat") Or InStr([MemberOF],"pets")