The following lists string functions:

Name Description
concat() Concatenates arguments into one CHAR string.
format() Converts FLOAT or DOUBLE to CHAR string with specified precision.
lpad() Returns a CHAR string left-padded with specified string.
rpad() Returns a CHAR string right-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.


RPAD

rpad(string, len, padstring)

RPAD function right 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.