I have a drop down that is populated the following query.
SELECT '%' AS Value,"Select Container" UNION Select CONCAT_WS(' ', style, type) AS Value, CONCAT_WS(' ', style, type) AS Label FROM container ORDER BY Value ASC
Based on the operators selection of this dropdown I would like to Make Visible( or invisible) other objects on the screen. By looking for key words, in this case the word Can or Bottle.
If it was a query I would search for ‘%Can%’.
What is the best way to accomplish this goal?