From m204wiki
(Redirected from $UPCASE)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.


$UPCASE(string [,language])


  • 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.


The following examples return uppercase strings for mixed case entries.

Function code... Returns... Language

$UPCASE('Name and address')


U.S. English

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


French Canadian

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


U.S. English

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