Syntax documentationstring_function Locate this document in the navigation structure

Syntax Syntax

  1. <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>
End of the code.