• Login

DataSoft Corporation

Case Sensitivity

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