Re: How can I get rid of carriage return?

I tried but it didn't work.

Roger Stapley (rstapley_at_uk.oracle.com) wrote:
: This message is in MIME format. Since your mail reader does not understand
: this format, some or all of this message may not be legible.

: ------_=_NextPart_000_01BF1C42.38CB0834
: Content-Type: text/plain;
: charset="iso-8859-1"

: 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,

: ------_=_NextPart_000_01BF1C42.38CB0834
: Content-Type: text/x-vcard;
: name="rstapley.vcf"
: Content-Disposition: attachment;
: filename="rstapley.vcf"
: Content-Description: Card for Roger Stapley

: begin:vcard
: n:Stapley;Roger
: tel;cell:0498 830701
: tel;fax:0118 924 7005
: tel;work:0118 924 7294
: x-mozilla-html:FALSE
: url:http://gain.uk.oracle.com/glob_index.html
: org:Stapley Consulting Limited
: version:2.1
: email;internet:rstapley_at_uk.oracle.com
: title:Consultant
: adr;quoted-printable:;;Building 560=0D=0AThames Valley Park;Reading;Berkshire;RG6 1RA;UK
: fn:Roger Stapley
: end:vcard

: ------_=_NextPart_000_01BF1C42.38CB0834--

--
Best regards, Received on Fri Oct 22 1999 - 08:18:10 CDT