Syntax |
UPPER(Text) |
Description |
Returns all letters in the given text as uppercase. Use the UPPER function to ensure consistent data entry of such things as state abbreviations or postal codes. |
Example |
UPPER ("Personalized Printing") => PERSONALIZED PRINTING |
Text |
Any text expression or data field containing a text. |
You can use this function to print the selected database field in capital letters.
If you are creating a mailing for which you need to print the names in capitals, although the names in the database are in lowercase, perform the conversion with UPPER.