Re: How can I get rid of carriage return?

Try SELECT REPLACE(field_one, CHR(10), ' ') FROM table;

suisum_at_ecn.ab.ca wrote:
>
> Hi:
>
> How can I get rid of carriage return? I want the data in a very long line
> without any carriage return.
>
> e.g SELECT field_one from table;
>
> THe value of the field_one must be in a very long line.
>
> THanks,

Received on Thu Oct 21 1999 - 18:11:01 CDT