Use this function to convert all characters to uppercase and return the result.
|
Parameter |
Description |
|
String |
Enter a valid string. The default is the value of the current field. |
|
Length |
Enter the length of the output. The default is the length of the current field. |
If the length specified in the Length parameter is longer than the string, the result is the length you specified. If the specified length is less than the string, the length of the string is used. The system does not truncate the string.
Here are some examples:
(Assume the current field contains the text Your Name.)
|
Function |
Result |
Explanation |
|
Upper ( ) |
"YOUR NAME" |
Defaults to the current field. |
|
Upper ( , 15) |
"YOUR NAME " |
Defaults to the current field and increases the length of the field to 15. |
|
Upper ("Street Address") |
"STREET ADDRESS" |
Uppercases the specified string. |
© Copyright 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices