I am currently trying to incorperate the LIKE statement to search strings in a database and return close matches. I'm making an inventory database and would like to search the Item Description field. It's going good so far but I was wondering if anybody had a good syntax for seaching.

Ex.

MyCheck = "aBBBa" LIKE "a*a"

thanks,

Jeremy