Gossamer Forum
Home : Products : DBMan SQL : Discussion :

using wildcards

Quote Reply
using wildcards
Hello

I have a simple table of birth registrations:

Year
Name
Surname
District
Volume
Entry No


The first 4 fields can be searched on, but data for all fields displayed in the results.

What I'd like to do is offer the searcher the option to use * as a wildcard, so if the searcher puts Jo* in the Name field, the results would bring up John, Joan, Jonathan etc.

Is this something that can be changed in the search script?

regards

Denise