Answer
Build the wildcard pattern using string concatenation around the parameter substitution, rather than trying to embed the wildcard character inside the parameter reference itself — for example, upper(description) LIKE upper('%' || '$SEARCH_PART_DESCRIPTION$' || '%'). Concatenating literal '%' characters on either side of the substituted parameter value is what lets a wildcard/contains-style match work correctly in a Lobby data source condition.