string_function

Grammar1: AdabasD V13n

<string_function> ::=
        <string_spec> || <string_spec> 
    |   <string_spec> & <string_spec>   
    |   SUBSTR    ( <string_spec>, <expression>[, <expression>] ) 
    |   {LFILL | RFILL} ( <string_spec>, <string_literal> [,<unsigned_integer> ] )
    |   {LPAD | RPAD}   ( <string_spec>, <expression>, <string_literal> [,<unsigned_integer> ] )
    |   {TRIM  | LTRIM | RTRIM} ( <string_spec>[, <string_spec> ] )
    |   EXPAND    ( <string_spec>, <unsigned_integer> )  
    |   {ALPHA | ASCII | EBCDIC | SOUNDEX | UPPER | LOWER | INITCAP   } ( <string_spec>[, <unsigned_integer> ] )
    |   REPLACE   ( <string_spec>, <string_spec> [, <string_spec> ] ) 
    |   TRANSLATE ( <string_spec>, <string_spec>, <string_spec> ) 
    |   MAPCHAR   ( <string_spec>[, <unsigned_integer> ] [, <mapchar_set_name> ] ) 

Referenced by:
<function_spec>

Grammar2: MaxDB V7_6n

<string_function> ::= 
  <string_spec> || <string_spec>
| <string_spec> & <string_spec>
| {GET_OBJECTNAME | GET_SCHEMA} (<string_literal>)
| {ASCII | INITCAP | LOWER | UPPER | SOUNDEX} (<string_spec>)
| {LTRIM | RTRIM | TRIM}(<string_spec>[,<string_spec>])
| {LFILL | RFILL} (<string_spec>,<string_literal>[,<unsigned_integer>])
| {LPAD | RPAD} (<string_spec>,<expression>,<string_literal>[,<unsigned_integer>])
| ALPHA (<string_spec>[,<unsigned_integer>])
| EXPAND (<string_spec>,<unsigned_integer>)
| MAPCHAR (<string_spec>[,<unsigned_integer>][,<mapchar_set_name>])
| REPLACE (<string_spec>,<string_spec>[,<string_spec>])
| SUBSTR (<string_spec>,<expression>[,<expression>])
| TRANSLATE (<string_spec>,<string_spec>,<string_spec>)

Referenced by:
<function_spec>