|
Function
|
Purpose
|
|---|---|
|
ASCII(str)
|
Returns the integer equivalent of string str
|
|
CHAR(code)
|
Returns the character equivalent of code
|
|
CONCAT(str1, str2)
|
Concatenates str2 to str1
|
|
strl { + | ||1 II) strl
|
Concatenates str2 to str1. For example:
SELECT str1 + str2, col1 ... SELECT str1 || str2, col1 ...
|
|
GET_UNIQUE_STRING(sfr)
|
This function generates a unique string, based on a "prefix" (the input string, which may be any string you choose) and a sequence number (which is created and used internally). If the input is NULL, the function still returns a string based on the unique sequence number.
|
|
INSERT(str1, start, length, str2)
|
Merges strings by deleting length characters from str1 and inserting str2
|
|
LCASE(str)
|
Converts string str to lowercase
|
|
LEFT(str, count)
|
Returns leftmost count characters of string str
|
|
LENGTH(str)
|
Returns the number of characters in str
|
|
LOCATE(str1, str2 [, start])
|
Returns the starting position of str1 within str2. If the optional argument, start, is specified, the search begins with the character position indicated by the value of start. If string_exp1 is not found within string_exp2, the function returns 0. For both the return value and the input parameter start, string positions are numbered starting from 1 (not 0).
|
|
LTRIM(str)
|
Removes leading spaces of str
|
|
POSITION (str1 IN str2)
|
Returns starting position of str1 within str2
|
|
REPEAT(str, count)
|
Returns characters of str repeated count times
|
|
REPLACE(str1, str2, str3)
|
Replaces occurrences of str2 in str1 with str3
|
|
RIGHT(str, count)
|
Returns the rightmost count characters of string str
|
|
RTRIM(str)
|
Removes trailing spaces in str
|
|
SOUNDEX(str)
|
Calculate 4-character soundex (phonetic) code
|
|
SPACE(count)
|
Returns a string of count spaces
|
|
SUBSTRING(str, start, length)
|
Derives substring length bytes long from str beginning at start.
For example, if str="First Second Third", then SUBSTRING(str, 7, 6) would return "Second".
String positions are numbered starting from 1 (not 0).
|
|
TO_CHAR(expression, format-string)
|
Returns a character representation of an input expression that has been formatted using a character template.
The TO_CHAR scalar function is a synonym for the VARCHAR_FORMAT scalar function.
|
|
TRIM(str)
|
Removes leading and trailing spaces in str
|
|
UCASE(str)
|
Converts str to uppercase
|
|
VARCHAR_FORMAT(expression, format‑string)
|
Returns a character representation of an input expression that has been formatted using a character template.
The VARCHAR_FORMAT function is a synonym for the TO_CHAR function.
|