This is version 1 2 3 4 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

INITCAP , UPPER and LOWER#

Functionality:#

These Oracle functions will return the passed character string with the capitalization changed as indicated:

• INITCAP will return the first letter of each word capitalized;
• UPPER will return all letters in UPPERCASE;
• LOWER will return all letters in lowercase.

Parameters: S#

STRING

The source, or original, string

Returns: Text

Errors: #

None

Example:#

initcap(~) will return, from a value of samuel sneed the value Samuel Sneed

upper(~) will return, from a value of samuel sneed the value SAMUEL SNEED