ASCII (string)
|
Returns a numeric value for the left most character of string. The value is the position of the character in the database code page. See also UNICODE function.
|
BIT_LENGTH (string)
|
|
CHAR (code)
|
Returns a single-character string where the code argument selects the character from the database code page. The argument must be an integer value. See also NCHAR function.
|
CHAR_LENGTH (string)
|
|
CHAR_LENGTH2(string)
|
|
CHARACTER_LENGTH (string)
|
|
ISNUMERIC(string)
|
|
LCASE or LOWER (string)
|
Converts all upper case characters in string to lower case.
|
LENGTH (string)
|
Returns the number of characters in string. Trailing spaces are counted in a VARCHAR, NVARCHAR, LONGVARCHAR, or NLONGVARCHAR string. Trailing NULLs are counted in a CHAR, NCHAR, LONGVARCHAR, or NLONGVARCHAR string. The string termination character is not counted.
|
Returns the starting position of the first occurrence of string1 within string2. The search within string2 begins at the first character position unless you specify a starting position (start). The search begins at the starting position you specify. The first character position in string2 is 1. The string1 is not found, the function returns the value zero.
|
|
LTRIM (string)
|
Returns the characters of string with leading blanks removed. All padding is significant for CHAR and NCHAR string.
|
NCHAR (code)
|
Returns a single-character wide string where the code argument is a Unicode codepoint value. The argument must be an integer value. See also CHAR function.
|
OCTET_LENGTH (string)
|
Returns the length of string in octets (bytes). All padding is significant for CHAR and NCHAR string.
|
Returns the position of string1 in string2. If string1 does not exist in string2, a zero is returned.
|
|
Searches string1 for occurrences of string2 and replaces each with string3. Returns the result. If no occurrences are found, string1 is returned.
|
|
Returns a character string composed of string repeated count times. The value of count is an integer.
|
|
REVERSE(string)
|
Returns a character string with the order of the characters reversed. Note that leading spaces in any string types are considered as significant, unlike trailing spaces which are not considered as significant. See Examples for an example.
|
RTRIM (string)
|
Returns the characters of string with trailing blanks removed.
|
SOUNDEX (string)
|
|
SPACE (count)
|
|
Returns a character string where length characters in string1 beginning at position start have been replaced by string2. The values of start and length are integers.
|
|
Returns a character string derived from string1 beginning at the character position specified by start for length characters.
|
|
UCASE or UPPER (string)
|
Converts all lower case characters in string to upper case.
|
UNICODE (string)
|
Returns the Unicode codepoint value for the left most character of string. See also ASCII function.
|