Function
|
Description
|
---|
ASCII(string)
|
Returns the ASCII code value of the leftmost character of string as an integer.
|
CHAR(code)
|
Returns the character that has the specified ASCII value.
|
CHAR_LENGTH(string) CHARACTER_LENGTH(string)
|
Returns the number of characters of the string.
|
CONCAT(string1, string2)
|
Returns a character string that is the result of concatenating string2 to string1.
|
INSERT(string1, start, length, string2)
|
Returns a character string where length characters have been deleted from string1, beginning at start, and where string2 has been inserted into string1, beginning at start.
|
LCASE(string)
|
Returns the specified string with all uppercase characters converted to lowercase.
|
LEFT(string, count)
|
Returns the leftmost count characters of string.
|
LOCATE(string1, string2[, start])
|
Returns the starting position of the first occurrence of string1 within string2. The search for the first occurrence of string1 begins with the first character position in string2 unless start is specified. If start is specified, the search begins with the character position indicated by the value of start. The first character position in string2 is 1. If string1 is not found within string2, 0 is returned.
|
LTRIM(string)
|
Returns the characters of string, with leading white space removed.
|
REPEAT(string, count)
|
Returns a character string composed of string repeated count times.
|
REPLACE(string1, string2, string3)
|
Search string1 for occurrences of string2 and replace with string3.
|
RIGHT(string, count)
|
Returns the rightmost count characters of string.
|
RTRIM(string)
|
Returns the characters of string with trailing blanks removed.
|
SPACE(count)
|
Returns a character string consisting of count spaces.
|
SUBSTRING(string, start, length)
|
Returns a character string that is derived from string, beginning at the character position specified by start for length characters.
|
UCASE(string)
|
Returns a string equal to that in string, with all lowercase characters converted to uppercase.
|