Convert to Lower/Upper Case (@contains)

[ovetteabejuela]

I observed that text comparison for 'contains' is case-sensitive. how can I convert to Upper/Lower case so that I still get the exact match regardless of case.

[Masterkeys]

Use the function toUpper or toLower as appropriate

[v-micsh-msft]

Adding the function reference:

toLower	Converts a string to lowercase. For example, this function returns two by two is four: toLower('Two by Two is Four') Parameter number: 1 Name: String Description: Required. The string to convert to lower casing. If a character in the string does not have a lowercase equivalent, the character is included unchanged in the returned string.
toUpper	Converts a string to uppercase. For example, this function returns TWO BY TWO IS FOUR: toUpper('Two by Two is Four') Parameter number: 1 Name: String Description: Required. The string to convert to upper casing. If a character in the string does not have an uppercase equivalent, the character is included unchanged in the returned string.

From here.

Regards,

Michael