Neoview SQL Reference Manual (R2.4)

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 473) or
“UCASE Function” (page 464).
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 240).
Considerations for UPPER
For one-to-one mappings for the UCS2 character set, see “Considerations for UCASE” (page 464).
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 395).
For examples of when to use the UPPER function, see “UPSHIFT Function” (page 473).
472 SQL Functions and Expressions