@UpperCase (Formula Language)

Converts the lowercase letters in the specified string to uppercase.


@UpperCase( string )



Text or text list. The string you want to convert to uppercase.

Return value


Text. The string, converted to uppercase letters.


If the parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.

This function is useful when you want to search for a particular value and cannot predict whether it will appear in lowercase, uppercase, or a combination of the two. You can also use it as an input translation formula to convert a field's contents to uppercase.


  1. This example returns ROBERT T. SMITH.
    @UpperCase("Robert T. Smith")
  2. This example returns MA if the State field contains "ma," "Ma," or "MA."
  3. This example returns FLETCHER if "William Fletcher" is the name associated with the current User ID. @UpperCase is used in conjunction with @Right to find and convert only the user's last name.
    @UpperCase(@Right(@UserName;" "))

    If the user id is a hierarchical id, the following code returns FLETCHER:

    @UpperCase(@Right(@Name([CN]; @UserName); " "))
  4. This example returns ROBERT and SMITH in a list.
    @UpperCase("Robert" : "Smith")