Database Searching

[AcornRanch]

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

[bsmith]

You might be better of using the LIKE in a SELECT statement from your database. That way you don't have to code this in VB.

    select INV_NUM from INVENTORY_TABLE where INV_NUM LIKE 'a*a'