SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-78
Examples of LOWER
Examples 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 on page 9-163.