AnsweredAssumed Answered

How do I create a search for whether a field "contains" a value rather than just "matching"?

Question asked by AM_1 on Jul 5, 2012
Latest reply on Jul 6, 2012 by philmodjunk

Title

How do I create a search for whether a field "contains" a value rather than just "matching"?

Post

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.

Outcomes