Use the CASE() function to convert a string to uppercase or lowercase.
The CASE() function has this syntax:
CASE({UPPER|LOWER},string)
The CASE() function takes these arguments:
Translates to uppercase.
Translates to lowercase.
1- to 256-character input string.
The CASE() function produces these return codes:
ARG n MISSING OR INVALID
Example
case('lower','ABC') == 'abc' /* Translate a string to lowercase */
case('upper','abc') == 'ABC' /* Translate a string to uppercase */
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |