The UPCASE function converts all alphabetic characters in a text expression into uppercase. When you specify a TEXT expression, the return value is TEXT. When you specify an NTEXT expression, the return value is NTEXT.
TEXT or NTEXT
The text expression whose characters are to be converted.
Suppose you get some new data to add to a mailing list. In the existing mailing list, people's names have the first letter capitalized. In the new data, however, the whole name is in lowercase. You can use UPCASE to make the new data correspond to the current data with a statement similar to the following.
lastname = JOINCHARS(UPCASE(EXTCHARS(lastname, 1, 1)), - EXTCHARS(lastname, 2, NUMCHARS(lastname)))