Syntax documentationstring_function Locate this document in the navigation structure

Syntax Syntax

  1. <string_function> ::=
      <string_spec> || <string_spec>
    | <string_spec> & <string_spec>
    | ALPHA (<string_spec>[,<unsigned_integer>])
    | ASCII (<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>)
End of the code.