how to use like function in access

[bunty]

thanks

[bunty]

:whistle: :whistle: hi..
Is there any LIKE command is available in access 2003.I have written one query where I need to find a record based on wild character .There I used Like but its not working.
anyone can u please give me a exact syntax or any other command for wildcard searching.

thanks

[OBP]

Like "*" * [data to search for] & "*"

[HiTechCoach]

This might help:

Overview of Access Queries (http://www.hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=37&Itemid=28)