Neoview SQL Reference Manual (R2.4)

Examples of UCASE
• 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 UCASE and LCASE
functions:
SELECT custname,UCASE(custname),LCASE(custname)
FROM sales.customer;
(EXPR) (EXPR) (EXPR)
----------------- ------------------- ------------------
... ... ...
Hotel Oregon HOTEL OREGON hotel oregon
--- 17 row(s) selected.
See “LCASE Function” (page 390).
For more examples of when to use the UCASE function, see “UPSHIFT Function” (page 473).
UCASE Function 471