How to use wild cards in saved search formulas CASE {expression} WHEN {expression} like ‘%’ || (condition) || ‘%’ THEN {expression} ELSE {expression} END For example: formula(text) –> CASE WHEN {location} like ‘%’ || (‘kerala’) || ‘%’ THEN ‘Temporarily Closed’ ELSE ‘Open” END