@UpperCase (Formula Language)

Converts the lowercase letters in the specified string to uppercase.

Syntax

@UpperCase( string )

Parameters

string

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

Return value

uppercaseString

Text. The string, converted to uppercase letters.

Usage

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.

Examples

  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."
    @UpperCase(State)
  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")