Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Function to remove spaces/carriage returns from text
REPLACE(column_name,UNISTR('\000D\000A'),' ')
This replaces the crlf with a space.
>Does anybody know how to remove a carriage return
>and line feed from text in an sql statement using some function
>or combination of functions.
>
Received on Wed Nov 29 2006 - 19:23:43 CST