Neoview SQL Reference Manual (R2.2)

Example of LOWER
Suppose that your CUSTOMER table includes an entry for Hotel Oregon. Select the column
CUSTNAME and return the result 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 “UPPER Function” (page 427).
358 SQL Functions and Expressions