How can I compare 2 fields in a Customer saved search for a match but ignore upper/lower case?
I tried Case When {email} like {custentity_invoice_email_address} then ‘Match’ Else ‘No Match’ End
I would like this result to be a Match.
My Criteria only returns rows that are No Match. I was hoping to exclude this row (and others like them).
Solution:
Try this:
CASE WHEN LOWER({email}) = LOWER({custentity_invoice_email_address}) THEN ‘Match’ ELSE ‘No Match’ END