Query to remove Carriage Return

[ejeffcott]

In need a query that would remove carriage returns from a section of a report.

I've tried various different ways, this is my latest:

select

c.casesummary

from

t_case c

replace(c.casesummary,chr(13)||chr(10),' ')


I keep getting an ORA-00907 error "missing right parenthesis"

ugh - i'm at a loss

 

[nagornyi]

select
replace(c.casesummary,chr(13)||chr(10),' ') casesummary
from
t_case c