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 Wed Jan 08 2003 - 22:01:52 CST
