Operators are case insensitive. Although field values’ case sensitivity depends on the data source.
A data source affects certain operators' behavior. For instance, by default, the SQL Server Express 2005 is configured as case insensitive. In this case, the following expression always evaluates to true:
Lower(Name) == Upper(Name)
Thursday, 27 December 2018 Posted in Expressions Constants, Operators, and Functions