Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Strange whitespace hard to trim off
what does
SQL>select dump(part) ...
give ?
s.kapitza
C Chang <cschang_at_maxinter.net> wrote in message news:<3E1CF430.2E7D_at_maxinter.net>...
> I have a record ( submitted by customer) as M123-1-9. When I count the
> length of it, it has 9 characters. I use -
> Select part , LENGTH(RTRIM(part)) p from ... to remove the whitespace
> off. However I still have 9 after the process. I have tried various
> chr() such as new-line, space, return character, none of them work. I
> tested with SUBSTR(part, 8,2) ||'*" and confirmed it to be a whitespace
> as 9 *. I just could not trim it off. Does anyone have a better
> suggestion?
> C Chang
Received on Thu Jan 09 2003 - 06:03:11 CST