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

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-74
LOWER Function
LOWER Function
Considerations for LOWER
Examples of LOWER
The LOWER function downshifts characters. LOWER can appear anywhere in a query
where a value can be used, such as in a select list, an ON clause, a WHERE clause, a
HAVING clause, a LIKE predicate, an expression, or as qualifying a new value in an
UPDATE or INSERT statement. The result returned by the LOWER function is equal to
the result returned by the LCASE function.
For UCS2, the LOWER function downshifts all the uppercase or title case characters in
a given string to lowercase and returns a character string with the same data type and
character set as the argument.
A lower case character is a character that has the “alphabetic” property in Unicode
Standard 2 whose Unicode name includes lower. An uppercase character is a
character that has the “alphabetic” property in the Unicode Standard 2 and whose
Unicode name includes upper. A title case character is a character that has the
Unicode “alphabetic” property and whose Unicode name includes title.
You cannot use the LOWER function on KANJI or KSC5601 operands.
LOWER returns a string of either fixed-length or variable-length character data,
depending on the data type of the input string.
character-expression
is an SQL character value expression that specifies a string of characters to
downshift. See Character Value Expressions on page 6-37.
Considerations for LOWER
Table 9-1 lists all one-to-one mappings for the UCS2 character set.
LOWER (character-expression)
Table 9-1. One-to-One Uppercase and Titlecase to Lowercase
Mappings (page 1 of 4)
x L (x) x L(x) x L(x) x L(x) x L(x) x L(x)
0041 0061 017B 017C 03EC 03ED 0536 0566 1E5C 1E5D 1F6B 1F63
0042 0062 017D 017E 03EE 03EF 0537 0567 1E5E 1E5F 1F6C 1F64
0043 0063 0181 0253 0401 0451 0538 0568 1E60 1E61 1F6D 1F65
0044 0064 0182 0183 0402 0452 0539 0569 1E62 1E63 1F6E 1F66
0045 0065 0184 0185 0403 0453 053A 056A 1E64 1E65 1F6F 1F67
0046 0066 0186 0254 0404 0454 053B 056B 1E66 1E67 1F88 1F80
0047 0067 0187 0188 0405 0455 053C 056C 1E68 1E69 1F89 1F81
0048 0068 0189 0256 0406 0456 053D 056D 1E6A 1E6B 1F8A 1F82