upper

This function converts lowercase characters in a text to uppercase. Other characters stay untouched.

This can be useful for comparing strings or for correction of misspellings, for example in names, labels, or for temporarily unifying text for further processing.

Syntax

upper(string)

Return

string

Examples

upper("upPer") 

Result: UPPER

contains(upper("With Ninox you can build great databases"), upper("database")) 

Result: Yes (true)

See also

lower, which returns a string in lowercase.