|Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number
B10339-02 REMBYTES(text-expression start [length]) The
expression from which REMBYTES removes bytes. When the
characters to be removed from text-expression contain embedded
line breaks, these breaks are also removed. Other line breaks
are preserved. Removed line breaks are not counted toward the
total number of characters removed. An integer that represents
the character position at which to begin removing characters.
The position of the first character in text-expression is 1.
When the value of start is greater than the length of text-
expression, REMBYTES simply returns text-expression. An integer
that represents the number of characters to be removed. When
length is not specified, only the character at start is removed.
When you are using a single-byte character set, you can use the
REMCHARS function instead of the REMBYTES function. This
function does not accept NTEXT arguments, because it is oriented
toward byte-manipulation instead of character