The following lists string functions:

Name Description
concat() concatenate arguments into one CHAR string.
format() convert FLOAT or DOUBLE to CHAR string with specified precision.
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.


FORMAT

format(number, precision)

FORMAT function converts a number to a CHAR string with specified precision.


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.