Help With Field Searching Using Wildcards

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Gang

I have a small database application where the user can search
different fields. They select what they want to search on and enter a
value to search on. For example

They select part number and enter "123" into the search field.

This searches the database for that field with LIKE '%123%'.

What I want the user to be able to do is add wildcards to the search.
For example

They select the part description field and enter "Dohicky*123" or
"Dohicky?123"

I want the search to process the wildcards as you would expect. What
is the easiest way to do this?

Regards,
Andy

.