How can I remove the newline character from the value of a column.
For Example:
Select name, comments from table where comment like '%Fine%';
Results:
NAME COMMENTS
John M. This was a
Fine piece of
work.
Above, I'd like the Results to appear:
NAME COMMENTS
John M. This was a Fine piece of work.
I tried substr, instr, hedged right ... but can't get it to work.
Any help will be greatly appreciated.
Regards
TS