Exact Match in Expression

I want a column value to be valid only if its last two letters (case sensitive) are in a list.

The current formula is

IN(Right([_THIS],2), {“ha”})

It works, but it accepts both ha and Ha. I want only values that end with ha, and prevent entries that end with Ha

2 - Is substitute formula case-sensitive?

0 11 665
11 REPLIES 11
Top Labels in this Space