The following lists string functions:

Name Description
concat() concatenate arguments into one CHAR string.
lpad() return a CHAR string left-padded with specified string.
substr() returns a CHAR substring as specified.

CONCAT

concat(string1, string2, ...)

CONCAT function concatenates multiple string arguments into one CHAR string.


LPAD

lpad(string, len, padstring)

LPAD function left pads string with padstring to a length of len CHAR string.


SUBSTR

substr(string, pos, len)

SUBSTR function returns a CHAR string with length len starting from position pos of string.