Neoview SQL Reference Manual (R2.5)

UPPER Function
The UPPER function upshifts alphanumeric characters. For non-alphanumeric characters, UCASE
returns the same character. UPPER can appear anywhere in a query where a value can be used,
such as in a select list, an ON clause, a WHERE clause, a HAVING clause, a LIKE predicate, an
expression, or as qualifying a new value in an UPDATE or INSERT statement. The result returned
by the UPPER function is equal to the result returned by the “UPSHIFT Function” (page 483) or
“UCASE Function” (page 481).
UPPER returns a string of fixed-length or variable-length character data, depending on the data
type of the input string.
UPPER (character-expression)
character-expression
is an SQL character value expression that specifies a string of characters to upshift. See
“Character Value Expressions” (page 255).
Considerations for UPPER
For one-to-one mappings for the UCS2 character set, see Appendix A (page 509).
Example of UPPER
• Suppose that your CUSTOMER table includes an entry for Hotel Oregon. Select the column
CUSTNAME and return in uppercase and lowercase letters by using the UPPER and LOWER
functions:
SELECT custname,UPPER(custname),LOWER(custname)
FROM sales.customer;
(EXPR) (EXPR) (EXPR)
----------------- ------------------- ------------------
... ... ...
Hotel Oregon HOTEL OREGON hotel oregon
--- 17 row(s) selected.
See “LOWER Function” (page 416).
For examples of when to use the UPPER function, see “UPSHIFT Function” (page 483).
482 SQL Functions and Expressions