How do I create a search for whether a field "contains" a value rather than just "matching"?
I have a search form in find mode. I want to be able to enter a search value in a field and for records to be found depending on whether they "contain" that value rather than just "match" the value. I know I could enter the value surrounded by wild cards (* value *) but I'm setting up the database for other users and want this to happen automatically.
Is there some way of changing the behaviour of a seach field to this, or is there some other simple and elegant way to do this? I'm sure it is a common requirement but I haven't been able to find an answer so far.
Thanks for any help.