| String Functions
| Function Returns
|
ASCII(string)
| Integer representing the ASCII code value of the leftmost character in string.
|
CHAR(code)
| Character with ASCII code value code, where the code is between 0 and 255.
|
CONCAT(string1, string2)
| Character string formed by appending string2 to string1. If a string is null, the result is DBMS-dependent.
|
DIFFERENCE(string1, string2)
| Integer indicating the difference between the values returned by the function SOUNDEX for string1 and string2.
|
INSERT(string1, start, length, string2)
| A character string formed by deleting length characters from string1 beginning at the start, and inserting string2 into string1 at the start.
|
LCASE(string)
| Converts all uppercase characters in string to lowercase.
|
LEFT(string, count)
| The count leftmost characters from string.
|
LENGTH(string)
| Number of characters in string, excluding trailing blanks.
|
LOCATE(string1, string2[, start])
| Position in string2 of the first occurrence of string1, searching from the beginning of string2. If start is specified, the search begins from position start. A 0 is returned if string2 does not contain string1. Position 1 is the first character in string2.
|
LTRIM(string)
| Characters of string with leading blank spaces removed.
|
REPEAT(string, count)
| A character string formed by repeating string count times.
|
REPLACE(string1, string2, string3)
| Replaces all occurrences of string2 in string1 with string3.
|
RIGHT(string, count)
| The count rightmost characters in string.
|
RTRIM(string)
| The characters of string with no trailing blanks.
|
SOUNDEX(string)
| A character string that is data source-dependent, representing the sound of the words in string, such as a four-digit SOUNDEX code, or a phonetic representation of each word.
|
SPACE(count)
| A character string consisting of count spaces.
|
SUBSTRING(string, start, length)
| A character string formed by extracting length characters from string beginning at start.
|
UCASE(string)
| Converts all lowercase characters in string to uppercase.
|
