You are here: All Help Topics > Accounting and Assurance > Calculations, Functions and Linkages > UPPER function

UPPER function

The UPPER function converts a string to upper case.

Syntax

UPPER(expression)

Example 1

UPPER("abcdef")

Displays the string "ABCDEF".

Database Filter

UPPER(DATABASE--> FIELD) OPERATOR VALUE

Example

GL->UPPER(JE_DESC)="MELVIN"

Returns all journal entries with journal descriptions that start with "MELVIN" regardless of case.

Operator	Description	Syntax	Example
<	Less than	value 1<value2	C1<C2 Condition is true if cell 1 is less than cell 2.
<=	Less than or equal to	value 1<= value2	C1<=C2 Condition is true if cell 1 is less than or equal to cell 2.
>	Greater than	value 1 >value2	C1>C2 Condition is true if cell 1 is greater than cell 2.
>=	Greater than or equal to	value1>=value2	C1>= C2 Condition is true if cell 1 is greater than or equal to cell 2.
=	Equal to	value1=value2	C1=C2 Condition is true if cell 1 is qual to cell 2.
<>	Not equal to	value1<>value2	C1<>C2 Condition is true if cell 1 idoes not equal cell2.

Related Topics

Copyright ©2017 CaseWare International Inc

| Visit us: www.caseware.com

Follow us