$Upcase

From m204wiki
Jump to: navigation, search

The $Upcase function translates a lowercase or mixed-case string into an uppercase-only string. The translation affects only the uppercase letters of the specified language.

Syntax

$UPCASE(string [,language])

Where:

  • The string argument represents the characters to verify, which must be entered as follows:
    • A literal enclosed by quotation marks.
    • A %variable.
    • A field name without quotation marks. In this case, the function call must be embedded in a FOR EACH RECORD loop where the current value of the field is verified.
  • The optional language argument specifies the language to use. The language argument is handled as follows:
    • Omitting this argument instructs Model 204 to perform the validation for U.S. English, even if the value of the LANGUSER parameter is not US.
    • An asterisk enclosed in quotation marks ('*') instructs Model 204 to use the value of the LANGUSER parameter.
    • A literal name of a valid language enclosed in quotation marks. If the name you enter is not supported, the request is canceled with an error message. See the LANGUSER parameter for the valid values.

Examples

The following examples return uppercase strings for mixed case entries.

Function code... Returns... Language

$UPCASE('Name and address')

NAME AND ADDRESS

U.S. English

$UPCASE('Île d'Orléans','FRENCHC')

ÎLE D'ORLÉANS

French Canadian

$UPCASE('Île d'Orléans')

ILE D'ORLeANS

U.S. English

Note: In U.S. English, no accented characters have case translation.