Wildcard search

[mattdillane]

The db i have written needs to be able to search using
wildcards
e.g. *abc123
allowing suffix and prefix searches.
What is the code?!?!?!?

I have recordset.findfirst code but i can't wildcard.
Somebody pleez help.

[Elias]

This is ADO Code, but it might work with DAO.

rstMain.Find "FirstName like 'Elias*'"