Like in a query

[damdoumaa]

Hello,
Does anybody know how I can use the LIKE operator in a query in Access 2000. I'm trying to put it in the where clause of my sql:

where Contacts.FirstName Like [forms]![search].[txtFname]

This query is not working. Does anybody know why? Can I use "LIKE" operator in Access 2000? If not, is there any other opertor that does the same thing?

thank you

 

[WayneRyan]

d,

where Contacts.FirstName Like "*" & [forms]![search].[txtFname] & "*"

Wayne

 

[damdoumaa]

Thank you Wayne, that was very helpful.