Neoview SQL Reference Manual (R2.3)

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 438).
LOWER Function 369