Upper()

Convert lowercase characters to uppercase characters.

Syntax

Upper(<cString>) --> cUpperString

Arguments

<cString> --> is the character string to convert.

Returns

Upper() returns a copy of <cString> with all alphabetical characters converted to uppercase. All other characters remain the same as in the original string.

Description

Upper() is a character function that converts lower and uppercase strings to uppercase. It is related to Lower() which converts upper and lowercase strings to lowercase.

Upper() is useful for formatting character strings for display purposes, comparing strings for matches where case is unimportant and for sorting when case should not affect ordering.

Examples

Upper('john smith')

* Result: 'JOHN SMITH'

cName1 := 'John Smith'

cName2 := 'JOHN SMITH'

Upper(cName1) == Upper(cName2)

* Result = TRUE (character strings match)

____________________________

Related Topics:

Business Function List