Filter data with varying notations (uppercase/lowercase)

If you use expressions that compare the content of a data field with another value (for example, when filtering the table data), be aware that the database contents may contain both uppercase and lowercase. The notation may vary, especially if the entry is provided by the user when preparing the measurement, as, for example, the sample name or sequence name. To ensure that all relevant records are considered, transform the database content to a standardized notation before comparing it.

Functions to transform the notation of data fields

Function	Syntax	Description
LCase	=LCase(fieldname)	Transforms all characters in the given field to lowercase.
UCase	=UCase(fieldname)	Transforms all characters in the given field to uppercase.

The complete entry in the Filter page would look like this:

Complete entry

Expression	Operation	Value
=UCase( Sample_Name )	=	TRAMADOL