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

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-162
Examples of UCASE
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 on page 9-69.
For more examples of when to use the UCASE function, see UPSHIFT Function
on page 9-164.
0x1FE7 0x03A5 0x0308 0x0342
0x1FF7 0x03A9 0x0342 0x0399
0xFB03 0x0046 0x0046 0x0049
Table 9-4. Three-Character UCS2 Mapping (page2of2)
Titlecase characters Three-Character Uppercase Expansions