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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to