Re: line breaks and tabs in a varchar2 column

From: Sean Welsh <seanw_at_order.com.au>
Date: Fri, 13 Oct 2000 17:48:00 +1000
Message-ID: <OcyF5.151$gD.4687@nsw.nnrp.telstra.net>

To answer my own (dumb?) question...

This worked for me...

update chartest
set charex =
(replace(replace(charex,' ',''),'
',''))

Regards,

Sean

"Sean Welsh" <seanw_at_order.com.au> wrote in message news:tJxF5.137$gD.4518_at_nsw.nnrp.telstra.net...
> Dear All,
>
> I have a table which has descriptions of items in a varchar2(2000) column
(v
> 8.1.5 sparc solaris).
>
> Some of these seem to have line breaks and tabs in them.
>
> Is there an easy way to get rid of them using SQL or by other means?
>
> Regards,
>
> Sean Welsh
>
>
Received on Fri Oct 13 2000 - 02:48:00 CDT