Have you tried a "select dump (field1) from table1" to see what ascii code corresponds to what you think is a carriage return?
> -----Original Message-----
> From: Hopper, Wendy S [mailto:[EMAIL PROTECTED]]
> >
> I am trying to write a query that strips carriage returns
> from a comment
> field while selecting the data to a file. I have used the following
> command -
>
> select replace( field1, chr(10), '*' ) from table1;
>
> The query seems to remove the carriage returns when returning
> the data via
> sqlplus, but when I spool the output to a file it still shows
> ^m followed by
> * in it. Any ideas on what is going on here?
