Is there a reasonably simple way to include a wildcard (e.g. an asterisk) in a database search string?
I've managed to create a working search form for a database collection, but would like to search the applicable fields with two wildcards. One of these would be an asterisk (*) to represent an unknown number of missing letters; the other would be a question mark (?) to represent a single unknown letter.
For information the database collection relates to ancient/medieval coins whose inscriptions are often only partially legible due to wear or the coin being incomplete. By entering a few surviving letters and using the above wildcards, the intention is to identify the coin by comparing the surviving details with full inscriptions from published sources. This project is an attempt to convert an M/S Access database I created many years ago to a web-based version.
Thank you in advance for any advice.