upper( ) Query Function

Upper-cases the contents of a string field.

Parameters

Name Type Required Default Description
field string Yes The name of the input field with the value to uppercase.
locale string No The name of the locale to use, as ISO 639 language and an optional ISO 3166 country, such as ‘da’,‘da_DK’ or ‘en_US’. When not specified, uses the system locale
as string No _upper name of output field

field is the unnamed parameter.

Examples

With an event with a field “Bar=contents, you get CONTENTS” in the ‘_upper’ field

upper("Bar")

With an event with a field “Bar=contents, you get CONTENTS” in the ‘Foo’ field

Foo:=upper("Bar")

With an event with a field “Bar=contents, you get CONTENTS” in the ‘Foo’ field

upper("Bar", as="Foo")