consider using the Oracle TRANSLATE function
"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 Mon Dec 10 2001 - 17:33:27 CST
