A string function is a function that supplies an alphanumeric value as a result.
Syntax
<string function> ::=
<string spec> || <string spec>
| <string spec> & <string spec>
| SUBSTR ( <string spec>, <expression>[, <expression>] )
| LFILL ( <string spec>, <string_literal> [,<unsigned integer> ] )
| RFILL ( <string spec>, <string_literal> [,<unsigned integer> ] )
| LPAD ( <string spec>, <expression>, <string literal> [,<unsigned integer> ] )
| RPAD ( <string spec>, <expression>, <string literal> [,<unsigned integer> ] )
| TRIM ( <string spec>[, <string spec> ] )
| LTRIM ( <string spec>[, <string spec> ] )
| RTRIM ( <string spec>[, <string spec> ] )
| EXPAND ( <string spec>, <unsigned integer> )
| UPPER ( <string spec> )
| LOWER ( <string spec> )
| INITCAP ( <string spec> )
| REPLACE ( <string spec>, <string spec>[, <string spec> ] )
| TRANSLATE ( <string spec>, <string spec>, <string spec> )
| MAPCHAR ( <string spec>[, <unsigned integer> ] [, <mapchar set name> ] )
| ALPHA ( <string spec>[, <unsigned integer> ] )
| ASCII ( <string spec> )
| EBCDIC ( <string spec> )
| SOUNDEX ( <string