Neoview SQL Reference Manual (R2.3)

UPPER Function
The UPPER function upshifts characters. 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 or UCASE
function.
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 218).
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 365).
For examples of when to use the UPPER function, see “UPSHIFT Function” (page 439).
438 SQL Functions and Expressions