Neoview SQL Reference Manual (R2.2)

Table 6-3 Two-Character UCS2 Mapping (continued)
Two-character uppercase expansionsTitlecase characters
0x03A9 0x03420x1FF6
0x03A9 0x03990x1FFC
0x0046 0x00460xFB00
0x0046 0x00490xFB01
0x0046 0x004C0xFB02
0x0053 0x00540xFB05
0x0053 0x00540xFB06
0x0544 0x05460xFB13
0x0544 0x05350xFB14
0x0544 0x053B0xFB15
0x054E 0x05460xFB16
0x0544 0x053D0xFB17
Table 6-4 Three-Character UCS2 Mapping
Three-Character Uppercase ExpansionsTitlecase characters
0x0399 0x0308 0x03010x0390
0x03A5 0x0308 0x03010x03B0
0x03A5 0x0313 0x03000x1F52
0x03A5 0x0313 0x03010x1F54
0x03A5 0x0313 0x03420x1F56
0x0391 0x0342 0x03990x1FB7
0x0397 0x0342 0x03990x1FC7
0x0399 0x0308 0x03000x1FD2
0x0399 0x0308 0x03010x1FD3
0x0399 0x0308 0x03420x1FD7
0x03A5 0x0308 0x03000x1FE2
0x03A5 0x0308 0x03010x1FE3
0x03A5 0x0308 0x03420x1FE7
0x03A9 0x0342 0x03990x1FF7
0x0046 0x0046 0x00490xFB03
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)
UCASE Function 425