Like operator, case insensitive

Hi I have some code as a conditional in IF statement


If NewEmail.Subject Like "*Product Refund*" or NewEmail.Subject Like "*product refund*" or NewEmail.Subject Like "*Product refund*" ...

I want to make the Like match case insensitive but I don’t want to create Like conditions for each combination. How do I do this?


We can convert both the string variables to UPPER CASE and then Compare

If (NewEmail.Subject).toUpper Like "variable.Toupper


@DEATHFISH - you can try like
NewEmail.Subject.ToUpper Like ‘PRODUCT REFUND
NewEmail.Subject.ToLower Like ‘product refund