I'm using the Search widget to query a feature layer. When a user enters a search string with more than one word e.g. WORDA WORDB the widget searches for the whole phrase "WORDA WORDB" within the search field:
SEARCHFIELD LIKE '%WORDA WORDB%'
So the user has to enter the precise text that is stored in the field being searched in order to get the correct results. If, for instance, the data contained a record with "WORDA, WORDB" in the search field, then this record would not be returned.
I would like the search to look for each word of the search string separately within the search field:
SEARCHFIELD LIKE '%WORDA%' AND SEARCHFIELD LIKE '%WORDB%'
I know we could tell the users to include the wildcards themselves and enter the search string as 'WORDA% %WORDB' but they may not be very IT-literate, so we don't feel this is a viable solution.