Show TOC

string_functionLocate this document in the navigation structure

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