DESCRIPTION
This is a set of single row character functions, defined for the datatype text. They are supposed to behave exactly as their Oracle counterparts.
The following functions have been implemented:
LOWER(string)
-
Returns string, with all letters forced to lowercase.
UPPER(string)
-
Returns string, with all letters forced to uppercase.
INITCAP(string)
-
Returns string, with first letter of each word in uppercase, all other letters in lowercase. A word is delimited by white space.
LPAD(string1, len [,string2])
-
Returns string1, left-padded to length len with the sequence of characters in string2. string2 defaults to blanks.
RPAD(string1, len [,string2])
-
Returns string1, right-padded to length len with the sequence of characters in string2. string2 defaults to blanks.
LTRIM(string [,set])
-
Returns string with initial characters removed up to the first character not in set. set defaults to blanks.
RTRIM(string [,set])
-
Returns string with final characters removed after the last character not in set. set defaults to blanks.
SUBSTR(string, m [,n])
-
Returns a portion of string, beginning at character m, n characters long. If n is omitted, to the end of the string. The first position of string is 1.
TRANSLATE(string, from, to)
-
Returns string after replacing all occurences of from with the corresponding character in to. TRANSLATE will not remove characters.