Re: Help! RTRIM keep running

CHAR is the fixed length string type. So all your values are padded with spaces to the 20 characters when you trying insert or update CHAR(20) column.

Use varchar2(20) type instead of CHAR(20), and read docs for differences between char and varchar types.

"Sunit Joshi" <sjoshi_at_ingr.com> wrote in message news:8f8ffe67.0112101458.3617e0a_at_posting.google.com...
> Hello All
> I have a table pdtable with a coln pipe_support_no which is char(20).
> It has entries like s1-c1", S2-C2" so on. I need to remove the " from
> the end, so I tried this
> update pdtable set pipe_support_no = rtrim(pipe_support_no,'"')
>
> But the update process keeps on running with no apparent results and I
> have kill the window. Any ideas what might be wrong here ???
>
>
> thanks
> Sunit
Received on Tue Dec 11 2001 - 15:01:24 CST