Function |
Description |
ASCII (string_exp) |
Returns the ASCII code value of the leftmost character of string _exp as an integer. |
BIT_LENGTH (string_exp) |
Returns the length in bits of the string expression. |
CHAR (code) |
Returns the character that has the ASCII code value specified by code. The value of code should be between 0 and 255. |
CHAR_LENGTH (string_exp) CHARACTER_LENGTH (string_exp) |
Returns the length in characters of the string expression, if the string expression is of a character data type; otherwise returns the length in bytes of the string expression. |
CONCAT (string_exp1, string_exp2) |
Returns a character string that is the result of concatenating string_exp2 to string_exp1. |
DIFFERENCE (string_exp1, string_exp2) |
Returns an integer value that indicates the difference between the values returned by the SOUNDEX function for string_exp1 and string_exp2. |
INSERT (string_exp1, start, length, string_exp2) |
Returns a character string where length characters have been deleted from string_exp1 at start and where string_exp2 has been inserted into string_exp1 at start. |
LCASE (string_exp) |
Returns a string where all uppercase characters in string_exp have been converted to lowercase. |
LEFT (string_exp, count) |
Returns the count leftmost characters of string_exp. |
LENGTH (string_exp) |
Returns the number of characters in string_exp, excluding trailing blanks. |
LOCATE (string_exp1, string_exp2 [,start]) |
Returns the starting position of the first occurrence of string_exp1 within string_exp2. The search begins on the first character position in string_exp2 unless the optional argument start is specified. If start is specified the search begins on character position indicated by the value of start. Character positions start at 1. The function returns 0 if string_exp1 is not found in string_exp2. |
LTRIM (string_exp) |
Returns string_exp with leading blanks removed. |
OCTET_LENGTH (string_exp) |
Returns the length in bytes of the string_exp. |
POSITION (string_exp1 IN string_exp2) |
Returns the position of string_exp1 in string_exp2. |
REPEAT (string_exp, count) |
Returns a string composed of string_exp repeated count times. |
REPLACE (stirng_exp1, string_exp2, string_exp3) |
Replace occurences of string_exp2 in string_exp1 with string_exp3. |
RIGHT (string_exp, count) |
Returns the count rightmost characters of string_exp. |
RTRIM (string_exp) |
Returns string_exp with trailing blanks removed. |
SOUNDEX (string_exp) |
Returns a character string representing the sound of the words in string_exp. |
SPACE (count) |
Returns a string consisting of count spaces. |
SUBSTRING (string_exp, start, length) |
SUBSTRING (string_exp, start, length) Returns the substring from string_exp beginning at start that is length characters long. |
UCASE (string_exp) |
Returns a string where all lowercase characters in string_exp have been converted to uppercase. |
Time, Date and Interval Functions
Data Type Conversion Functions