Using beast mode to compare strings
Hi, I am trying to compare the values of 2 fields using a CASE WHEN statement. "field1" contains an email address e.g. "bob@test.com" "field2" may contain a name and email, e.g. "Bob Smith, bob@test.com" The outcome I would like from my beast mode is to check if the value in field1 is contained within the value of field2.…