ORACLE_COMPAT(SQL)

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 lower-
              case.

       UPPER(string)
              Returns string, with all letters forced  to  upper-
              case.

       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. TRANS-
              LATE will not remove characters.