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
HEX() Convert value into hexadecimal representation
LEFT() Return the specified leftmost number of characters in a string
LENGTH() Return string length
LOCATE() Return the position of a substring within another string
LOWER() Convert all letters in the specified string to lowercase
LPAD() Return a CHAR string left-padded with specified string
LTRIM() Remove leading spaces
RIGHT() Return the specified rightmost number of characters in a string
RPAD() Return a CHAR string right-padded with specified string
RTRIM() Remove trailing spaces from a string
SUBSTR() Return a CHAR substring as specified
SUBSTRING() Same as SUBSTR()
UPPER() Convert all letters in the specified string to uppercase

CONCAT

concat(string1, string2, ...)

The CONCAT function concatenates multiple string arguments into one CHAR string.


FORMAT

format(number, precision)

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


HEX

hex(value)

The HEX function converts a number or string to hexadecimal representation.


LEFT

left(string, n)

The LEFT function returns the leftmost n characters in string.


LENGTH

length(string)

The LENGTH function returns the length of the given string.

--

LOCATE

locate(string1, string2, [start_pos])

The LOCATE function returns the position of the first occurrence of string1 in string2 starting at position start_pos. It returns 0 if string1 is not in string2. If start_pos is not given, it is assumed to be 1.


LPAD

lpad(string, len, padstring)

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


RIGHT

right(string, n)

The RIGHT function returns the rightmost n characters in string.


RPAD

rpad(string, len, padstring)

The RPAD function right pads string with padstring to a CHAR string with length len.


SUBSTR

substr(string, pos, len)

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