|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
TEXT or NTEXT
When the expression is TEXT, the return value is TEXT. When the expression is NTEXT, the return value is NTEXT
The text expression whose characters are to be converted.
Example 8-16 Converting Part of an Expression to Lowercase
Suppose you get some new data to add to a mailing list. In the existing mailing list, people's names have only the first letter capitalized. In the new data, however, the whole name is capitalized. You can use LOWCASE to make the new data correspond to the current data with a statement similar to the following.
lastname = JOINCHARS(EXTCHARS(lastname, 1, 1), - LOWCASE(EXTCHARS(lastname, 2, NUMCHARS(lastname))))