| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: newline in sql
> I tried translate(field,hextoraw('0D'),'something
> else'), but the hextoraw doesn't seem work at all.
Hi
Your on the right lines but you need to do replace(field,chr(13),'something else') this will replace all the CRs with something else
HTH Jason Received on Tue May 19 1998 - 11:30:21 CDT
 |
 |