Task parameter lookup acting like combined filter

In my opinion, this should be a no-brainer. Regardless of the context, searching on multiple keywords like this seems like basic functionality to me.

However, it is difficult to determine whether to search inclusively (using OR) or exclusively (using AND). In other words, do we want the results to match both keywords or do we want them to match either one keyword or both. In the most general sense I would assume using OR would be the go-to. Perhaps this should be a dropdown, where the end-user themselves can opt whether to search inclusively or exclusively?

In either case, implementing this should be as simple as splitting the input on a whitespace character and inserting each resulting item into the query as a separate LIKE-clause.

Following @htimmermans’ example;

WHERE
    [dbo].[item].[field]
        LIKE '%Kleppe%'
        OR '%afstel%'

Above example assumes inclusive searching, exclusively the OR would be replaced with AND in the above clause.

The debugger shows the search string is directly inserted into the query on the underlying table or view as a LIKE-clause, so it seems this would need to be a GUI function. That should make implementing this easier, since the user input can be mutated before it is sent to the database.