Like operator, case insensitive

Help
1

Hi I have some code as a conditional in IF statement

e.g.

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?

2

hi @DEATHFISH,

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

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

–
Mukesh

3

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