I have a list of terms in a field called Lines of Business containing records like:
I’m trying to use the rules engine to return partial matches where the field contains the substring. I’ve tried a few different variations use LIKE and MATCHES and even simple =
$Lines of Business$ LIKE “?DENTAL?”=> “LikeDental”
$Lines of Business$ LIKE “DENTAL”=> “LikeDental”
It should return “LikeDental” for all the example records, above. However I can only get the exact match to return a result. I seem to be missing something obvious. Any helpful ideas?