Trying to find a string within a string in a dataset. Example CASE WHEN ‘Red, Blue, Green’ LIKE ‘%Blue %’ THEN ….
However these are fields rather than an entered string in the formula. CASE WHEN {custbody_colors) LIKE %{costbody_color}% won’t validate.. either will ‘%{custbody_color}%’
Any ideas?